Dotan Cohen wrote:
I do not understand what the form does. It appears to me that when I
select a,b from one side, it tries to select b,a from the other. it
doesn't exactly work, but as it doesn't fit what we need here I'll
leave it at that. I do appreciate your attempt at helping, though.
It is not trivial to filter the content of a list box to make it offer
only a subset of selectable items, it is possible, though.
List boxes pick items by name, usually writing a foreign key (ID number)
into the form's field. Each journey gets a city-ID from either one of
the list boxes.
The suggested solution on the orange form lets you type the first
letters of a country name into the box in order to find the correct city
within a country or you can type the first letters of a city name to
find the right one in the right country or region in case of duplicate
city names.
The same works well with concatenated personal attributes like
"Forename"||','||"Surname"||','||"Birthday"
or
"Forename"||','||"Surname"||','||"Company"
The second form is dysfunctional. I should have deleted that one since I
had no time to finish.
OK, OK. Here is the second version where I added departure times to the
voyages and finished the other form where you pick a city for a new
journey by preselected country: http://www.mediafire.com/?mt0mouiznjj
Browsing through records with 2 interdependent list boxes for city and
country takes a macro to update the country after updating the city and
update the filtered cities after modifying the country of one existing
voyage.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
