Table Lookup or Query?

[epicmove]

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

 

[epicmove]

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.