Hi

Is there a way on RSForm Pro that you can have a cascading dropdown which gets the information from a table on the database?

I have seen an example on your demo for putting Car Manufacturers and Car Models but instead of listing them in the javascript I would like to grab the data from the table.

The table is set out like this:

County Table:

id -> county_name -> county_id
1 Devon 1
2 Avon 2

Town Table:

id -> town_name -> county_id
1 Exeter 1
2 Exmouth 1
3 Bristol 2

If the county equals let say "Devon" for that county it will have an its own county id which will also be marked in the Town Table, so for each town in that county it will have that counties id.

So if the person selects Devon from the dropdown it will only show the Towns in that relevant County

I hope i have shown this correctly, if there is a way to accomplish this would you be able to point me in the right direction.

I have asked this as a support question, however I tought I would put it on the forum as well just incase someone else knew, plus this may help someone else out if they are after the same thing

Hi proexe

I've a similar problem but couldn't find a solution yet.

Did you get an answer from Support or another source?
If yes, please post it here.

Maybe with some Ajax code?

Thanks,
Tom

Hi Guys,

This is all I have been able to find in regards to this. Haven't yet tried it but wanted to share.

demo.rsjoomla.com/dynamic-drop-down-change-form-example

-Wol