How to have multiple categories and subcategories within the same receipt.

[ManuelLavesa]

Hello, I am trying to make a database for expenses etc... I have a table Receipt, another table named Description and Another named Category. When I get a receipt that has for example Groceries, and Clothes I need to make three records one for the receipt total, one for Groceries total and one for clothes total. Groceries and Clothes are Descriptions but then Groceries is Category Food, and Clothes is Category Daily Living. I heard of joint tables that You use the primary key of each table, and then make them all the primary key on the new table and you can have the result I am looking for. But would this work for three tables joint into one table? Is there any better way? Thank you for your help.

[ranman256]

i have a table of Cats, with sub divisions.
you can have queries: qsFood, qsVehicles
or join to the tCatagory table and filter on the CATA

CATA	SUBCAT
Food	Groceries
Food	Burgers
Food	Fries
Daily Living	Clothes
Daily Living	Makeup
Daily Living	coats
Vehicle	Cars
Vehicle	Boats
Vehicle	Airplane