Recording Payments Into One Table From 3 Table Sources
I have three tables set up in FM 11: Product sales quotes, product sales invoices and service sale invoices. I need to be able to record payments through one easy to use table. I've created the new table called Payments and made a field called reference number in the table - among some other fields. I made a relationship from each of the first three tables to the new payments table by connecting their reference number fields to the Payment tables reference number field.
From there I'm not sure what to do. I'd like to have one layout to go to that shows all unpaid invoices from all three tables. Any help is appreciated and I can answer more questions about the setup.