7 Replies Latest reply on Sep 19, 2011 8:34 AM by ChloeF

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

    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