Hello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.

Our clients make multiple payments for the same order. They may make a
deposit with a Check then pay the balance with a Credit Card.

I am trying to make a section on the invoice that shows the date of each
payment and the last 3 digits of the card used or the check number.

I have a querie that finds all records in the "Payments" table with the same
"OrderID". How can i make a section on the Invoice that will display ony the
payments for the current invoice?

I assume that I need to link the OrderID on the current report but i cannot
figure out how to display the information, especially when there is more than
one payment.

Thanks for the help...
-H-