Conditional drop down list using validation show if?
I need to make a conditional drop down list, but not sure how to make this happen.
I made these tables in my database.
[ CountryCategory ]
id CountryCategory shops
1 1 shope#1
2 1 shope#2
3 2 shope#3
4 2 shope#4
And form area with 5 drop down menu for;
[shops in England]
[shops in Wales]
[shops in Scotland]
[shops in Ireland]
It should work like this;
When a country name is chosen from a list populated with CountryCategory;
another dorp-down list appears depending on which country is chosen;
If 1 (England) is selected from [CountryCategory], a drop-down list of [shops in England] will appear, and so on.
What's the best way to do this?
I read "Getting Start with Validation Tool" hoping to help me to understand, but the logic of validation is confusing me… you purposely make errors so you get to see/use "show if"?? Also, I'm confused with "Validation show if" and "show region utility".
Could you briefly tell me the steps to make this happen so I'll know where to start?
Thank you for your help,