i have 2 multi value fields that contain similar or related value for example Field A contains Department Name and Field B Contains Department Manager.
Field A(Department) Field B(Department Manager)
IT Dept Joe Depth
HR Dept Louie HArd
Admin Dept Henry See
Accounting Dept Chu Yuan
now i need to create a Combobox(using DBcolumn) that contain the list of all Department(Field A) and if i select 1 value i will get the designated department manager..
how can i do that?