Creating Invoices from 2 related tables
I'm after some pointers on how best to achieve this I don't have a specific query. I have 2 tables Customers and Transactions. Customers is populated with information about the customer, it has a form view with a portal to the transactions table where related transactions can be added to the transactions table.
I want to make a button that will create an invoice, however I don't want all the related records from transaction showing, just the relevant one or two. I could make a new table called invoices and make a script to populated fields with customer information, no problem but I'm not sure on how to only display the few records I want from the transactions table.
Thanks in advance.