Tables won't relate
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.