Linking of individual records to tables.

[Dinoid]

Wondering if anyone can tell me if and how it is possible
to link a table or subtable to a record in a field of
another table. For instance the parent table has one
field called vehicle make, and in that field are several
records (i.e. Alpha Romeo, BMW, VW etc). Is it possible
to link a models(1 series; beetle etc) drop down
menu/table to each vehicle make, so that when you press
BMW you only get the BMW models. I'm not that up with the
correct terminology of Access so I hope I'm making sense.
Thanks in advance.

 

[Jeff Boyce]

Dinoid

It sounds like you are trying to do data entry directly in a table. Access
tables store data. Access forms display it (and do data entry).

If I understand correctly, you want to be able to make one selection (?auto
manufacturer?) and have a second selection limited to those models belonging
to the first selection.

In a form, you'd use two combo boxes, and in the AfterUpdate event of the
first (?manufacturer), you'd requery the second (which will use the value in
the first as a selection criterion).