I have an issue where I have two sets of related fields (one being populated by a database table and the other via a cascading drop down) Whenever I change the value on one field it blanks the cascading dropdown in the other set.
To illustrate the issue I have created a test site.
http://ec2-54-208-68-174.compute-1.amazonaws.com/test1/index.php
If you click on test form and add you will see the following fields
Set1 (You can view data by clicking on Country in the menu)
Country Name (Database Join)
City Name (Cascading dropdown)
Set2 (You can view data by clicking on People in the menu)
People State (Database Join)
People County (Cascading dropdown)
The two sets are no related to each other however if I change one value it blanks fields in the other set. For example if you edit a record with all four fields populated by changing Country Name it will blank city name as it is supposed to but it will also blank People County.
To illustrate the issue I have created a test site.
http://ec2-54-208-68-174.compute-1.amazonaws.com/test1/index.php
If you click on test form and add you will see the following fields
Set1 (You can view data by clicking on Country in the menu)
Country Name (Database Join)
City Name (Cascading dropdown)
Set2 (You can view data by clicking on People in the menu)
People State (Database Join)
People County (Cascading dropdown)
The two sets are no related to each other however if I change one value it blanks fields in the other set. For example if you edit a record with all four fields populated by changing Country Name it will blank city name as it is supposed to but it will also blank People County.