automatically loading values in combo boxes

[saleemMSMS]

i have the following view
attendant type | attendant number | program name |
Shop owners 678 Book Keeping
Farmers 679 cultivation
Players 680 discipline

now, i have 2 combo boxes. what i want is when i select an attendant number from the first combo box, i need the second combo box to automatically get filled by the relevant attendant type.
for example, if the 679 is selected in the first combo box, it should automatically select the type as "Farmers" in the second Combo box,
how can i do this ?

 

[John Big Booty]

It sounds like you are looking for a Cascading Combo box set.

 

[Galaxiom]

You should also normalise your AttendantType and ProgramName data rather than working with the strings.

Also recommend you drop the spaces from your field names.