AnsweredAssumed Answered

Tables won't relate

Question asked by TonyArcangelini on Aug 20, 2015
Latest reply on Aug 20, 2015 by TonyArcangelini

Title

Tables won't relate

Post

I am creating a database to help us with our weekly inventory and ordering. There are multiple locations that all take inventory on separate tables. On each table there is a field for cups to order. I am attempting to pool all the "Order" entries on a separate table for the purchasing manager to see without having to go to each location and see the quantity but cannot seem to figure out the best way to do this. I attempted to make a joined table but can't get the records to display from the relationship. I am fairly new to FMP and am not sure what I am missing here... I attached a picture of my relationships to clarify. 

relations.jpg

Outcomes