Two databasejoin in a form, the second depending on the first

[tali]

Hi,

I'm trying to put two databasejoin in a form.
First one is "Countries"
Second "Towns"

How can I populate the Towns dropdown list according to the choice made in the Countries list ?

Is it built in Fabrik, or do I have to program this through Javascript plugins on the change event ?

 

[troester]

It's the cascading dropdown element you are looking for.

 

[tali]

Cascading dropdown a great solution when the two tables are fabrik tables.

In case you have two databasejoin

example : first dropdown is Languages and second is Categories
The Categories dropdown should show only the categories related to the chosen Language

What would be the solution in that case?

 

[rob]

I'm not sure why you cant use the cascadingdropdown still? You can always make a Fabrik list from an existing database table, create a new list and under the data section, rather than supplying a new database table name, select the exisitng database table from the dropdown list.

 

[tali]

Brilliant!

It points out that a "Fabrik list" rather than being directly bound to a MySQL table is more precisely
an object working (at least in your solution) as a Wrapper (from a pattern design point of view)