value that's dependent on another value

[mr martini]

i'm creating a table that records car sales. my database has 4 tables: 1)
car manufacturers 2) chevy models 3) gmc models and 4) pontiac models. in my
car sales table, there's a manufacturer field and a model field (both are
combo boxes). i want the values of the model field to be dependent on the
value of the manufacturer field. for example, if i select pontiac as a
manufacturer, i want the source of the model field to be the pontiac models
table. is this possible? thanks

 

[KARL DEWEY]

You need to combine your tables 2, 3, and 4 together. Just add a field to
distinguish the car line.

Search on Cascading Combo Boxes.

 

[mr martini]

thanks! does this work in tables or just forms?

You need to combine your tables 2, 3, and 4 together. Just add a field to
distinguish the car line.

Search on Cascading Combo Boxes.

 

[KARL DEWEY]

I do not understand your question. Does what work in forms?

 

[mr martini]

i combined the tables, but its still not working. i'm able to select the
manufacturer by setting the row source to the distinct manufacturers in the
table. i'm still unclear how to then select the model. for example, if my
table has 2 records- a pontiac and a chevy- my model combo box is showing
both the pontiac and chevy models (as opposed to showing just the pontiac
models for recoed 1 and just the chevy models for recoed 2). i appreciate
your help w/ this!