4 Replies Latest reply on Mar 28, 2013 11:23 AM by MattLeach

    Relationship Issue

    MattLeach

      Working on an inherited FM11 solution that i can't seem to figure out.

       

      There are 3 tables involved:

      Customers

      Orders

      LineItems

       

      I've attached a sample file to demonstrate when i'm attempting to do/correct.

       

      Each customer can have multiple orders, each order can have multiple line items.

       

      I would like to make a printout of an order showing all line items for that order (Order Review layout). The problem is that this layout shows all line items related to the customer, not just the order.

       

      Im probably overlooking something so thats why i did a quick sample file duplicating what is in the file to see if someone can point out what im missing.

       

      Thanks