So this is my situation at the moment:

I have a table called PAYMENTS in which i record payment on invoices (generic information).

I then have another table called REBATE which has all the detailed information (including the generic which is pulled in from Payments) with a line per line item in the invoice and lots of other info on the line item.

Would it be possible that from the Payments table i create a BUTTON that would pull all the line entries in the REBATE table and show them in a sensical manner for the user to understand?

Thanks in advance

M