I want to populate consecutive fields in a table

W

Wayne

I want to use drop down selections to quickly enter some
info, and I want to have the first field determine what
choices I can make in the second, and so on.

I have three fields specifically that I would like to
use. Manufacturer, Device_Type, and Model. I have a
spreadsheet with 103 Manufacturers, 17 Device types, and
lots of model numbers. I would like to dump this into a
database and use this to enter specifc information that
pertains to my location. I have a table that contains the
manufacturers only(tblMfr), and one that contains the
device types only(tblDvcTyp), and 1 called tblMstr which
has the following fields; Manufacturer, Device_Type, Model
and ID. I don't know what relationships to establish
between these tables and the one that I want to use to
enter further information (serial numbers, rooms etc), or
how to get the info from the first collumn to narrow down
the selections for the next.

Any ideas?

Thanks!
 
J

Jeff Boyce

Wayne

Don't use tables for data entry.

In Access, tables store data, forms (and reports) display it.

Using "cascading combo boxes" is a common approach in form design.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top