>I have two listboxes on a form, say a Country and a City.
>When I go up down the country ListBox, I just want to show the cities relevant to the specific country
>My List Boxes come from a Country and City table, the City table also having its parent (the Country) as one of the fields.
>
>How do I get the Cites to display on the listbox, but just those relevan tot the country that is currently highlighted.
>
>Thanks in advance.
>regards,
>Gerard
One possibility is to use a local view with CountryID as parameter, e.g.
select * from Cities where CountryID = ?m.CountryID
In interactiveChange of first combobox set CountryID = this.value and then requery the view and cities combobox.
If it's not broken, fix it until it is.
My Blog