Calculation thru relation or subset of records?
I'm new to FM and I'm creating a multiple location database. I'm currently working on showing totals for each item in each location.
I have 3 tables that I think the data should relate from.
My Inventory list (which shows the general description of my items)
cQtyonHand (which ads up the cItemBal from the Item_transaction table)
Item Transaction Table
I currently have a lay out based on the Inventory list which shows Item information total on hand and has a portal to the location table and displays where the items are. What I want to add to that portal is how many of each item are in each location. It should be a calculation that totals the cItemBal, but only for the item on that layout and for each location it is in. So I think that its somehow but a subset and relational, but I'm not getting it to work.