Split choice control (or other method to implement this?)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Grahammer (dont.spam_at_me.here)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 13:06:57 -0600

I have the followin relationships in my table...

  Province 1->M Cities 1->M Centres
  Province 1->M Centres

... One country can have many Cities. Once City can have many Centres. The
Centres that are available in a City is limited by the Country.

Ontario -> Toronto -> East York
Ontario -> Toronto -> Scarborough
Ontario -> Toronto -> Mississauga
Alberta -> Calgary -> Downtown
Alberta -> Calgary -> Rundle

..and..

Ontario -> East York
Ontario -> York
Ontario -> Etobicoke
Ontario -> Scarborough
Ontario -> Missisauga
Alberta -> Downtown
Alberta -> Rundle
Alberta -> Woodbine
Alberta -> Country Hills

... You'll notice in the top secition that not all of the Ontario Centres
did not appear for Toronto. Ditton for the Alberta Centres.

I'm trying to find a simple MS Access form (it's a child form placed on the
Cities form) to implement the ability to add and remove Centres from the
Cities, based on what Centres are available in the Province. I'm trying to
use as little VBA as possible.

I considered two list boxes, with and "Add->" and "<-Remove" button, similar
to what is found in many Windows apps, but the list boxes require different
queries, and I can't figure out how to limit their results based on the
parent form.

Is this description clear? Can someone suggest how this can be done?

Relevant Pages

  • Re: The good ole CBC
    ... I ain't bitin' on the 'provincial debate' (albeit the current Ontario ... what the Alberta government (and ... what do the pathetic governments of this country ... clean up your consumption habits, ...
    (rec.sport.curling)
  • Re: The "Paris, France" thing, sort of
    ... Of Ontario place-names, I can see a potential need to ... Country" thing strikes me as a lot less logically ... At the level of national broadcasting, ... Come to think of it, I wonder if another reason for the " City, ...
    (alt.usage.english)
  • Re: Canada tour ... Waiting for suggestions on the place!
    ... Montreal is a city. ... Alberta is still largely in winter until May, ... while Ontario and Quebec thaw out much earlier. ... tour from any city on the southern tour. ...
    (rec.travel.usa-canada)
  • Re: QFTCIMI5 Game 5 Rounds 9-10: breweries, challenge round
    ... Arkell Bitter, Iron Duke, Trailhead lager; Ontario. ... In which country will they be held? ... Russell Brand is currently doing very well as a mad English rock ... Which railway station in London is named after a British ...
    (rec.games.trivia)
  • Re: Calgary Welcomed Ann Coulter
    ... Ontario, when she told a Muslim Student to " Take a Camel ". ... Alberta separating from the rest of Canada now that they've got a lot ... penalty in your country for that is 15 years in Prison. ... government puts you on the no entry list...>> ...
    (rec.boats)