Okay... I have a table of all my products. There's a table called order_items that linked to the products table. Each order item is linked to one product. The order_items also contains information on how much of of an order's payment went to that specific order_item. Each product in the needs to add up how much money was spent on it total. I made a calc field in the products table that just did a sum(order_items::paid), but that field is always blank. I don't know why, because I've used sum this way in other parts of the database, and it always works. I noticed that filemaker thinks my relationship between products and order_items is many to many when it should only be 1 to many. Will that make a difference? If so how do I correct filemaker?

Thanks.

Okay... I have a table of all my products. There's a table called order_items that linked to the products table. Each order item is linked to one product. The order_items also contains information on how much of of an order's payment went to that specific order_item. Each product in the needs to add up how much money was spent on it total. I made a calc field in the products table that just did a sum(order_items::paid), but that field is always blank. I don't know why, because I've used sum this way in other parts of the database, and it always works. I noticed that filemaker thinks my relationship between products and order_items is many to many when it should only be 1 to many. Will that make a difference? If so how do I correct filemaker?

Thanks.

Okay... I have a table of all my products. There's a table called order_items that linked to the products table. Each order item is linked to one product. The order_items also contains information on how much of of an order's payment went to that specific order_item. Each product in the needs to add up how much money was spent on it total. I made a calc field in the products table that just did a sum(order_items::paid), but that field is always blank. I don't know why, because I've used sum this way in other parts of the database, and it always works. I noticed that filemaker thinks my relationship between products and order_items is many to many when it should only be 1 to many. Will that make a difference? If so how do I correct filemaker?

Thanks.