AnsweredAssumed Answered

How can I show the products ordered from an invoice into the customer table?

Question asked by ChloeF on Sep 7, 2011
Latest reply on Sep 19, 2011 by ChloeF

Title

How can I show the products ordered from an invoice into the customer table?

Post

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?

Screen_Shot_2011-09-07_at_4.39.36_PM.png

Outcomes