Do a filter/find on two dropdown lists (state/town)
Hey I was hoping someone could help me with this problem.
I have two fields on one layout which are both dropdown lists. The user has to first choose which state they live in (first dropdown list), then directly below it in another dropdown list choose which town from that state.
Now how do I narrow the list of towns in the second dropdown list based on which state was chosen in the first dropdown list?
Thanks in advance for any advice I could get on this problem.