How can I show the products ordered from an invoice into the customer table?
See the picture for the relationships. I am using the Invoices FM Solution (a little modified).
My customer table is called "Vessels", and my Invoice is set up so that it shows a portal from the table "Line Items".
I would like those line items from the all the invoices linked to the vessel to show in a portal in a tab, on the "Vessel" form.
I could set up a portal with the invoices without trouble but when I'm doing the same pulling from the "Line Items" table, it doesn't show anything.
I was used to Access before, could you help me out?