hi, i want to make a invoice statement report with detail payment record. can u tell me how to do that as below....

DATABASE (INV)
DOC_NO.......990001
DOC_AMT......100


DATABASE (PAYMENT)
DOC_NO.......990001
PAID_DATE....01/01/1999
PAID_AMT.....10

DOC_NO.......990002
PAID_DATE....02/02/1999
PAID_AMT.....20

DOC_NO.......990002
PAID_DATE....03/03/1999
PAID_AMT.....30

vvvv STATEMENT vvvv

INVOICE NO : 990001 AMOUNT 100
paid 01/01/1999...10
paid 02/02/1999...20
paid 03/03/1999...30
OUTSTAND..........40

pls...sent the .PRG & report form to HS_HK@yahoo.com
thank...very much