I try to accomplish conditional logic, where user
1) selects Country
2) based on selected Country, see's list of Province / State = (to select/ autofill drop-down)
3) based on selected Province / State, see's list of cities = (to select/ autofill drop-down)
Should I first create.
1) DB with all countries + States ?
2) DB with States + Cities
3) "big" DB table with all Countries + States + Cities
Should I create 1 (very large) Form,
where the "State" selection is (in)visible based on conditional logic?
where the "City" selection is (in)visible based on conditional logic?
Selection field 1 = Country
Then Quantity of Selection field 2 (state) to create = qty of Countries (in the world)
Then Quantity of Selection field 3 (city) to create = qty of states (in the world)
Seems like a lot of work.. must be a better way.
Probably there already an example...
Is there a (video) link to a step-by-step to accomplish this easiest way?