hello again, (dwmx, mysql)

i have a table named tblPersonnel with fields: Id_pers, employ_number, initials, lastname.

on a form, i have a dynamic droplist(menu/list) with the values from the employ_number column in the above tbl.

what i want to do is to : once i select the value(employ_number) from the droplist, it must automatically apply the initials and lastname in the 2 text fields next to the droplist.

for example:

| MENULIST_HERE | INITIALS_FIELD | LASTNAME_FIELD |

i select the employee's number from the menulist, and then the initials and lastname display in the 2 fields next to it. the 2 textfields doesn't HAVE to be textfields, it's just there for display, not for edit.

is this possible ?

any advice, please !

thank you,

Jamie.