selectbox populate by selectbox table list

[lamany77]

Hi all
i've 2 selectbox :

first : selectbox : name of table1,name of table 2, name of table2, ....etc.
second : selectbox : populate base on first selectbox choose.

how do i make the schenario

[arbei]

You may read Tutorial - Dynamic Selection List.

[lamany77]

i meant

i have 3 table :

• master table a, name : d_master1
• master table b, name : d_master2
• master table c, name : d_master3

those 3 master table is listed on 1st select box :

1st selectbox : d_master1
d_master2
d_master3

2nd selectbox (- will be populate with data from d_master1 if user choose d_master1
- will be populate with data from d_master2 if user choose d_master2.
- will be populate with data from d_master2 if user choose d_master3)

could you help for that case ?

.

[arbei]

You may create a view to join the 3 tables and use the view as lookup table for the 2nd selection list.

[sangnandar]

If the master tables form a tree-like data hierarchy, it would be a great idea to retune your database by using "table closure" (you can google this term).