9 years ago
5
Topic

Hi, I have three table Table1, Table2 and Table3. My case is that Table1 Cascade Table2 and Table3 too. In Table1 there are two fields one for Table2 and one Table3 I can't grab this. Any Help please.

Get a Book for SEBLOD
9 years ago
1
Level 1

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

9 years ago
0
Level 2

See here what I want.

9 years ago
1
Level 1

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

9 years ago
0
Level 2

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.

9 years ago
0
Level 1

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

Get a Book for SEBLOD