Forms and Select Value

[cspectra]

I am new to MS Access, and try to learn and use 2007 version. So far I can do basic things but running into one difficulty that I don't have any clues to find solution. Any hints, and examples will be very much appreciated.

I have the following tables:

System table with 4 entries
PowerCat, OamCat, AuxilCat, and TestCat

Power table with 2 entries
AC, and DC

OAM table with 3 entries
Laptop, Server, and Peripheral

Auxiliary with 3 entries
Voice, Data, and Mediate

Test with 3 entries
Instrument, Tools, and Miscelaneous

Since parts are overlapped, I join several other specific-part tables together to make new 4 Category tables named as PowerCat, OamCat, AuxilCat, and TestCat

Now I like to make a new "AssetList" table where after the first field selection from System table such as "PowerCat", I can pick the appropriate catergory table for the other fields of the part.
Can somebody tell me how to do it. I don't know much about VBA object properties, but very much pulled in. Also, I would like to make a form to add new asset item, using the same scenario if possible.

Thank you in anticipation.