Hello.

I hope somebody has a solution for this type of scenario.

I have 4 tables, Contact ( in SM database ), Country, State and City ( these
3 tables in MASTER database ).
Contact table, the primary key is Id, the table has 3 other fields,
CountryId, StateId, CityId.
Country table, the primary key is Id, which is a country id.
State, the primary key is CountryId + Id
City, the primary key is CountryId+StateId+Id

I've set 3 Lookup combo and they are all seems to work fine.
If I choose another Country, the other 2 would go blank.

The problem arise when I tried to update a contact, for example who lives in
( County - State - City ids ) USA - TX - TX.
I want to update to Singapore which has Country, State, City Ids of SIN -
SIN - SIN.
When I chose Country=SIN, the 2 others combo gone blank and I can actually
commit the transaction. Now the values would be SIN - TX - TX, which is
wrong.

1. Is there a simple and quick way to solve this ( such as adjusting some
properties of IBO components ) ?
I can not use foreign key since the 3 tables not in the same database.

2. It also seems that the State and City combo can not filter the list.
For example, when I chose SIN in the Country, the drop down State still
display USA states, etc. It supposed to only list the SIN's state.

TIA
Andy