field drop down dependent on another field

[JNW]

I have a table that has the user select a Division from a drop-down (items
are done through lookup to a Divisions table).

I would like the next field to let the User choose a subdivision that is
relevant to the Division that was chosen.

How do I do this? I have already created a subdivision table that has a
key, the subdivision names and a field for the division that relates to each
subdivision.

Thanks

 

[KARL DEWEY]

I do not know if it can be done in tablesb but you will find many post that
say not to use lookups in a table. You should do the lookups in a form that
has the table as source.
Then you would want to search on 'Cascading Combos.'

 

[JNW]

Thanks. I'll look into that.

I do not know if it can be done in tablesb but you will find many post that
say not to use lookups in a table. You should do the lookups in a form that
has the table as source.
Then you would want to search on 'Cascading Combos.'