Populate List

[nouf]

hi,,
please any one can help me in doing the following:
i have two tables
dept_code d_name
--------- ------
1 aa
2 bb
3 cc
sec_code dept_code s_name
----------------------------
1 3 ss1
2 1 ss2
3 3 ss2

i populated dept table into a list field called dept
what i want is after selecting the department populating the sections into
a sec field depending on the selected department.
so when i select dept 3 i found only sections
1 and 3 into the sec field
thanx in advance

 

[HimanB]

Hi,
Whatever code you have written to Populate the Sec name list, write it again on the the trigger when-list-changed of List item deptname & add the where clause to it accordingly.

i.e. when deptcd=:blockname.deptcd.

HTH
Regards
Himanshu