Dependent fields

ayz

https://editor.datatables.net/examples/api/dependentFields.html talks about one scenario type.

Another type is for example countries and states fields. Immediately the user selects a new country, the state's field is updated with a new list of label/value pairs from the states table in the database.

If here is no automatic way to handle this is Editor, I presume it will mean setting up dom level events for the country field and that triggers a reload of states field. The SQL for states in the backend PHP will however need to refer to refer to the currently selected value of country. For this the where...use combination would need to be used.

Please confirm if this is correct and any other guidance. I always prefer to have a clear roadmap to avoid getting into debut loops.

allan

Hi,

Have a look at this blog post which discusses exactly this topic.

Allan