Two combo with relationship

[ckleung]

Hi,
I create 3 tables, they contain the names of "Area1", "Area2" and "Area3." Another table named "Region" that contain "Area1", "Area2" and "Area3."
Then I create a form. I want to achieve the following:
I make two comboboxes. One conneted to "Region." How to do when I select "Area1", the other combo will contain the names of Area1 for me to select; and if I select Area2, it will contain the names of Area2 .... and so on.

Can anyone help? Thanks in advance.


ckleung

 

[Mile-O]

Can anyone help? Thanks in advance.

First of all: scrap the three table idea and use this:

tblRegions
RegionID (autonumber - make this the primary key)
Region (text - the name of your regions)

tblAreas
AreaID (autonumber - make this the primary key)
Area (text- the name of your areas
RegionID (number - this gets related to the RegionID in tblRegions)

Once you have this structure in place you can then create a proper set of Cascading Comboboxes. (a term with which has been done to death here and, therefore, will return loads of results in the forum's search function)

 

[ckleung]

I don't understand

Dear Mr. Phile,

Once you have this structure in place you can then create a proper set of Cascading Comboboxes. (a term with which has been done to death here and, therefore, will return loads of results in the forum's search function)

Thanks for your advice, but I don't understand the above statement. What is "a set of Cascading Comboboxes?" How to do that? Should I make relationship among the tables I created as you said. Please give me more detail lession because I am too new for this.

Thanks a lot!

 

[Mile-O]

There's loads of examples and there's an FAQ in the FAQ forum. However, here's a quick example of what I mean:

 

[maxmangion]

do a search on this forum for "Cascading Combo Boxes" and you will find plenty of examples. There is also a good example in the FAQ!