Filtered Dropdown on Form
Hi everyone, so I am trying to create a dropdown for user to pick in a form and the dropdown need to be filtered from user previous selection. But if previous selection is not selected, user still be able to pick the dropdown and select from it.
To make it easier to understand, let say I have a form (in table called Main Table) with three dropdowns (State, County, and City from three tables) and State < County < City. If user pick Texas in State, then County dropdown will filter to only show Counties in Texas. But if user decide not to pick anything in State, the County dropdown will show all County in every states. Then if they pick Dallas County then City will filter to only cities in Dallas County and State will still be empty.
I am aware of Conditional Value (in Field Settings) but it requires user to first pick State in order to pick County. I am open to any suggestion and solution. Feel free to ask if you need me to explain more.