> 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. >
Thanks, Andreas! This is quite what I need to do, and the button press is fine. I have a lot to learn from this database, it should keep me busy for quite a while! Last question, if I may? Where in the docs would I have found this? I really am trying to get up to speed with Base but there is so much info that I am drowning. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
