Hello.
Thanks for the help above.
Suppose I have the following tables:
tblCategory
--> CatID, CatName, totalSpent
tblItem
--> ItemID, ItemName, ItemCost, ItemCat, RecID, CatID
tblReceipt
--> RecID, RecStore, totalCost
These tables have the following relationships:
CatID<(1)--(Many)>ItemID...