Dear List,
I have a form with 4 combo boxes. (Province, District,
County and Village).
I want the user to select the Province and have all
the Districts that pertain to the selected province
show up in the District combo box. Similarly, when a
district is selected, I would like the county combo
box to show all relevant counties and when a county is
selected I would like all villages for that county to
show up in the Village combo box.
I have already designed 4 tables:
a)List_Province_Name with 2 fields Province_ID and
Province_Name.
b)List_District_Name with District_ID, District_Name
and Province_ID fields
c)List_County_Name with County_ID, County_Name and
District_ID fields
d)List_Village_Name with Village_ID, Village_Name and
County_ID.
The tables are related.
This is where I am stuck. I need help structuring the
SQL statements and events.
Thanking you in advance for your help.
Sincerely,
Irshad
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
