value that's dependent on another value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mr martini - 23 Jun 2006 16:52 GMT

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

Reply to this Message

KARL DEWEY - 23 Jun 2006 17:45 GMT

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.

> 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
[quoted text clipped - 3 lines]
> manufacturer, i want the source of the model field to be the pontiac models
> table. is this possible? thanks

Reply to this Message

mr martini - 23 Jun 2006 19:32 GMT

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.
[quoted text clipped - 8 lines]
> > manufacturer, i want the source of the model field to be the pontiac models
> > table. is this possible? thanks

Reply to this Message

KARL DEWEY - 23 Jun 2006 20:50 GMT

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

> thanks! does this work in tables or just forms?
>
[quoted text clipped - 10 lines]
> > > manufacturer, i want the source of the model field to be the pontiac models
> > > table. is this possible? thanks

Reply to this Message

mr martini - 23 Jun 2006 22:05 GMT

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!

> I do not understand your question. Does what work in forms?
>
[quoted text clipped - 12 lines]
> > > > manufacturer, i want the source of the model field to be the pontiac models
> > > > table. is this possible? thanks

Reply to this Message