Multiple Payments - one invoice

C

Cyndi

I have one invoice that can have many payments/adjustments. I have my
tables written and everything seems to be working except when I output
to report


SAMPLE REPORT
Inv Amount Payment
1 15,000 7,500
1 7,500 3,750
1 3,750 0.00

This is how my reports needs to look -I can get it to print the detail
lines but I cant make the amount column increment like my sample above
- also I dont know if this will matter but amount initially pulls from
a linked to another dateabase table and I cannot fiddle to much with
that field

Can you point me in the right direction here?/

Any help always appreciated!!!!
 
Top