Please examine the Company sample application that mixes together the
master-detail and keylinks relationships. If you can tell me how to
duplicate your undesirable behaviors in this context there is probably
something I can do to address them.

This one sounds pretty hard to do so I am going to need a sample of some
kind to play with.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Andy Samuel" <andysamuel@...>
To: <IBObjects@egroups.com>
Sent: Thursday, January 18, 2001 3:11 AM
Subject: [IBO] Lookup Combo


> 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
>
>
>
>
>