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
