sincronize two combos in ADP

  • Thread starter Thread starter alecarnero
  • Start date Start date
A

alecarnero

I have two fields city and state the two are combobox , is posible
sincronize these comboboxs ,
example when i choose the city :pasadena (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
 
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
 
Thanks Candance your idea is right
Candace said:
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
Click to expand...
 
Back
Top