Synchronise drop down lists
I am trying to sync drop down lists as shown below:
All the records in Region show, only records in location show that are related to Region appear, only records in facility show that are related to location etc.
I have a relationship diagram below also.
I seem to be having a lot of trouble trying to get them to work.