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.