Help required in 3 Cascading List Box: one filtering the other

S

suprakashG

Hi,
I need some help in this cascading list box problem....I browsed through the
posts for cascading list boxes but being pretty novice couldn't resolve my
problem. Here it goes....

Table 1:
countryID_PK (Text)
countryName (Text)

Table 2:
stateID_PK (num)
stateName (Text)
countryID_PK (Text)

Table 3:
CityID_PK (num)
cityName (Text)
stateID_PK (num)

Relationships:
Table 1>>Table 2 is 1-Many
Table 2>> Table 3 is 1-Many

I have three List boxes called lboCountry,lboState,lboCity.I want the values
of lboState to get populated based on the country selected in the lboCountry
and subsequently the lboCity to get populated based on the state selected in
the lboState. Here as usual City is a State is a subset of Country and a
superset of City.... Please help me out.... I have posted this in Forms
category also so ignore if you have seen it there.

Thanks
Suprakash
 
G

Guest

Please do not multi-post! Your question was answered in the Forms group
already.

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top