Access - Auto populate fields

[reicherb]

I?m building a database for inventory and so far have the following tables (below).

My issue is that I want to track hardware specs in the PCs (CPU, memory, etc) but don't want to have to populate those fields manually every time. Is there a way to have those fields populated when a model number is selected? I'd still like them to be able to be changed, but I'd like the default configuration for that model to be entered.

Thanks.


building/room table
building
room
equipment ID

PC table
equipment ID
make
model
serial
etc

Monitor table
equipment ID
make
model
serial
etc

Printer table
AV equipment table
etc

 

[bunker]

You'd have to build a lookup table with the columns <model> <cpu> <ram> <etc...> and then build a front end with a drop down to select the model which can then populate the database.

 

[reicherb]

Yes, I get the concept, but how do I build the front end?

 

[bunker]

Originally posted by: reicherb
Yes, I get the concept, but how do I build the front end?

How were you planning on entering the data in the original database????
I don't have the time it would take to teach you how to do it.