selectbox populate by selectbox table list

PHPMaker General Discussion (PHPMaker)
1

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

2

You may read Tutorial - Dynamic Selection List.

3

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_master32nd 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 ?
    .
4

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

5

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).

6

I’ve get your idea and i’ve make a view union table and everything goes smooth.
thank you very much