Linking tables conditionally

[dcurtis]

I am very new to Access and am doing my best not to sound too stupid. I have been working with it for 2 days and not doing too bad at it for that amount of time.
I downloaded some templates from MS and have studied them but can't figure out how too accomplish what I need.

I am attempting to build a PC inventory database for our company and have several tables setup as follows...

Computer Info.
Fields = Mfg | Type | Model
Computer MFG
Fields = Dell | Gateway
Computer Type
Fields = Desktop | Laptop
Dell Desktops
Fields = "Dell Desktops" with all models we purchase listed
Dell Laptops
Fields = "Dell Laptops" with all models we purchase listed
Gateway Desktops
Fields = "Gateway Desktops" with all models we purchase listed
Gateway Laptops
Fields = "Gateway Laptops" with all models we purchase listed

Computer Info. is my main table that the other tables will be linking into. But, here is where I am getting confused.

Example" When I choose "MFG" Dell and "TYPE" Laptop I only want it to show choices from the "Dell Laptops" table.
Example" When I choose "MFG" Dell and "TYPE" Desktop I only want it to show choices from the "Dell Desktops" table.
Example" When I choose "MFG" Gateway and "TYPE" Laptop I only want it to show choices from the "Gateway Laptops" table.
Example" When I choose "MFG" Gateway and "TYPE" Desktop I only want it to show choices from the "Gateway Desktops" table.

All Key Fields in all tables are "Auto Number"


Let me know if this doesn't make sense or if you need more information.

I would appreciate all advice and help you can give me.

[TheShabz]

This only needs one table.
tblPCInventory:
ComputerID
CompMFG
CompType
CompModel

You just enter all the info there and then query for what you want. you dont need to search multiple tables for the criteria you want. Lets take your first example:
Example" When I choose "MFG" Dell and "TYPE" Laptop I only want it to show choices from the "Dell Laptops" table.
query for that would be:
SELECT *
FROM tblPCInventory
WHERE CompMFG = "Dell" AND CompType = "Laptop"

This will now provide you with all records that are Dell Laptops.