Dynamic Select Dropdown

I am trying to create dynamic drop down system
Regions and Districts.
When a user selects a Region in Drop Down 1, the options of Dropdown 2 must change to values attributed to that region.

Two tables in the Db Pictures below REGIONS TABLE

region
region894×388 15.7 KB

DISTRICTS TABLE

districts
districts823×311 13.2 KB

MY FORM
form

I have followed the tutorials below without success. I get the regions to show alright but the Districts drop down does not work. Can some one please help me understand the key things required for this to work both on db side and application side?

  1. https://www.dmxzone.com/go/32764/dmxzone-app-connect-manual/32769/dynamic-dependent-drop-downs-part-2-large-data-sources-3000-records

  2. https://www.youtube.com/watch?v=diTYf5GGJ58

Community Page
Last updated: