Two Tables working together

512 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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


0 Replies 0