Hello osantomas,

welcome on SEBLOD forum.

Without more informations we won't be able to help you.

The minimum would be the complete configuration of your 3 selects in the cascade.

Best regards.

Lionel

See here what I want.

Hello osantomas,

to allow other users to follow the post, I write here your configuration :

Table #__circunscripcion

• id
• circunscription

Table #__provincia

• id
• provincia

Table #__municipio

• id
• provincia_id
• circunscripcion (name)

For me, you don't need the first table, so I advise :

for the first select of the cascade :

• query : construction
• Behavior : start
• Group identifier : mygroup
• Table : #__provincia
• option name : provincia
• option value : id

So for the second select of the cascade :

• query : construction
• Behavior : End
• Group identifier : mygroup
• Table : #__municipio
• option name : circunscripcion
• option value : id
• parent : provincia_id

Best regards.

Lionel

hi, this is my structure

Table #__provincia
id
provincia

Table #__municipio
id
provincia_id
municipio

Table #__circunscripcion
id
circunscripcion

Table #__provincia_circunscripcion
id
provincia_id
circunscripcion_id

Table #__person_type
id
type

Table #__person
id
person_type_id
*provincia_id (NULL) // Condiconal value from Table #__person_type

*municipio_id (NULL) // Condiconal value Table #__person_type

*circunscripcion_id (NULL) // Condiconal value Table #__person_type

//The fields marked with (*) will be fill it depending on selection from Table #__person_type.

As you can see, Table #__provincia and Table #__municipio work perfectly on cascade.
But Table #__provincia_circunscripcion holds provincia_id and circunscripcion_id, what I wanto to cascade is Table #__provincia with a SQL Query from ( Table #__circunscripcion and Table #__provincia_circunscripcion) or a View in order to show circunscripcion.

Hi osantomas,

so many table for the hint seem to be disproportionned to my eyes.

Your problem seem to be more about conception and Mysql query than a disfunctionnment of the cascade field.

For this kind of request we have some support package where we can help you directly on your website.

Best regards.

Lionel