AnsweredAssumed Answered

Help with a relationship

Question asked by scoot_ya_boot on Feb 3, 2017
Latest reply on Feb 3, 2017 by philmodjunk

To preface, I'm a novice user. I have Filemaker Pro Advanced (14, I believe), and I'm trying to create relationships across a few tables. What I'm attempting to do is compare what was ordered from the "LB_Order_Info" table to what was produced in a table called "Alb_Incoming_Shipments_Item". For further explanation, the "LB_Order_Item" table has a portal that's related to the "Alb_LB_Order_Item" table. In LB_Order_Item, I key the week that the product was produced for, and then in the portal associated with Alb_LB_Order_Item, I type in the item number, and the amount ordered.


On another set of tables, I have "Alb_Incoming_Shipments," where I key in the information from the delivery slips created by the production facility, into another portal related to "Alb_Incoming_Shipments_Item". This portal/table contains the item number, the quantity shipped, and the week it was produced for.


What I'm trying to do is create a layout with LB_Order_Info as the table, with only the only field being production week, then place a portal inside of it that shows the item number, the quantity ordered (from Alb_LB_Order_Item table), and the quantity shipped (from the Alb_Incoming_Shipments_Item table).


I've attached a screenshot of my relationships. If you see "BUSS" or "BUSS_Number," that's the item number I'm talking about above.


Thank you in advance!