Hi Guys,

Would like some advise on my database structure.
I have a main Asset Table recording IT Equipment.

Two of the fields in the Asset Table are Equipment_Type and Equipment_Type_Specific i.e. PC > Desktop

There is an Equipment_Type table with a child table Equipment_Type_Specific

The Asset Table needs to look up to these tables for the Equipment Type values.
The Equipment_Type_Specific field will be a cascading combo so that the user can only select Laptop,Desktop,Tower etc. if it is a "PC".

Would it be best to have these two Fields in the Asset Table looking at a query so that the names are saved in the Asset table rather than the Key reference of the various Equipment Types?

Thanks

Would it be best to have these two Fields in the Asset Table looking at a query so that the names are saved in the Asset table rather than the Key reference of the various Equipment Types?This is a non sequitur. Using a query rather than a lookup has nothing to do with saving the names rather than the IDs.

apologies for the question...

realise this now. Having read more into normalisation I am using SQL lookups to queries and storing the ID (integer) values in my tables.