Custom fields to Nested Select Lists

Hi all,
I need help with custom fields....
I've 2 tables that are related:

Table 1 - regioni: id, name
Table 2 - province: id, name, id_regione

Field 1 is a select list thru a SQL: SELECT id AS value, name AS text FROM `xxx_regioni` ORDER BY name
Field 2 is a select list than depend from field 1.... how I can do that? :

SELECT id AS x.value, x.name AS text FROM `xxx_province` AS x LEFT JOIN .... ?????

Tnx in advance for help
Matteo

The question is where you want to use the dependency ?

In item form?

While the page is already rendered and given to the browser ? Then you need to use JAVASCRIPT and AJAX since you are in browser and not at server (where you can use PHP)

So,
the user selects a value in field 1, and then you want to effect field 2 and make it display something that depends on the selected value in field 1?

This is not trivial to make , you would need to create a new custom-developed FLEXIcontent field, we plan to offer an easy way to do it in the select field (without need to create a custom-developed field)

Hi,
tnx for reply I'm so new to Flexi....

I'd like to put fields in the form.....

ggppdk wrote: the user selects a value in field 1, and then you want to effect field 2 and make it display something that depends on the selected value in field 1?

Exatly..... the target is: nation -> region -> city ..... and then use FlexiGmap

The solution is too complex for me (JAVASCRIPT and AJAX)..... have you an example ????

It is possible to do something without modifying FLEXIcontent plugin files

You could load all values in second field and create a js file with jQuery commands that will attach
- to the onchange event of field 1
- initially hide all value in field 2
- when field 1 changes they will filter field2 and appear some options

This is custom development that can be done from a professional.

We plan to offer a similar effect built-in , but this is not currently available

Is it 2.1 feature? I saw that somewhere....