knfruitbat
New member
- Local time
- Today, 05:25
- Joined
- Jun 6, 2019
- Messages
- 2
Hello.
1st post, so please be patience.
I have created two Drop Down Combo boxes on a form. I have link the first one to a table that has two columns that have repeated values in each column. So in the first box I have linked to select say country, and then I want the results in the second combo box to show only towns within that country. No free-typing allowed only select from the drop downs.
I have the first combo box working fine, it gives me a perfect concise list with no repeats (all in table does repeat multiple times), but the second combo box just keeps coming up blank. I have probably made it overly complicated by creating a second table with a unique identifier for each country, when I am really just interested in those two columns.
Just in case this matters, the towns aren't always unique. So for example we can have multiple entries for some countries, but others only one. But we also have towns that are the same in different countries. i.e Edmonton in Canada, and Edmonton in England.
Thanks for any help, hope this makes sense.
1st post, so please be patience.
I have created two Drop Down Combo boxes on a form. I have link the first one to a table that has two columns that have repeated values in each column. So in the first box I have linked to select say country, and then I want the results in the second combo box to show only towns within that country. No free-typing allowed only select from the drop downs.
I have the first combo box working fine, it gives me a perfect concise list with no repeats (all in table does repeat multiple times), but the second combo box just keeps coming up blank. I have probably made it overly complicated by creating a second table with a unique identifier for each country, when I am really just interested in those two columns.
Just in case this matters, the towns aren't always unique. So for example we can have multiple entries for some countries, but others only one. But we also have towns that are the same in different countries. i.e Edmonton in Canada, and Edmonton in England.
Thanks for any help, hope this makes sense.
