How do you get a summary on related values
I have an inventory database with a related month-end count database.
The count sheets use the inventory database as their layout database.
If I change the layout to the month end count database, I can get a summary for the value of inventory. However, the count sheet only show inventory items the have values in them and I want to show the complete inventory.
Is there a way to show the summary of values in a related table?