sincronize two combos in ADP

[alecarnero]

I have two fields city and state the two are combobox , is posible
sincronize these comboboxs ,
example when i choose the city asadena (2) afterupdate the select
automatically the state california

my table of city is like this

city state
pasadena 2
los angeles 2
El paso 3

and the state table is

id state
2 california
3 texas

Thanks in advance

Alejandro Carnero
Santos -Brazil

 

[Candace]

Why are they two separate combo boxes?

Why not have one field for both? Have a table that has a
numeric identifier, a field for city and a field for
state. The user will select a number for city / state
which is stored in that record and display the city name
and state name as text boxes. This does not work as well
when you have the same city name in more than one state.
You would need to have a unique record for each city /
state combination.

You can also do it through programming but what I
suggested above is simplier.

Candace

 

[alecarnero]

Thanks Candance your idea is right

Why are they two separate combo boxes?

Why not have one field for both? Have a table that has a
numeric identifier, a field for city and a field for
state. The user will select a number for city / state
which is stored in that record and display the city name
and state name as text boxes. This does not work as well
when you have the same city name in more than one state.
You would need to have a unique record for each city /
state combination.

You can also do it through programming but what I
suggested above is simplier.

Candace