Thanks for the response Naomi.

I'm probably "overthinking" it all... please forgive me...

The employee table has sex as a FK so I am wanting to have the combo box to have the data for the sex types and update the fk field in the v_empdemo view with the corresponding fk. That way, when they move the record with the navigation buttons, the correct sex that corresponds to the employee will be relflected in the combo box...

But at the same time, to reflect the diff sex to choose from should the user decides to chage the sex.

Here is the is small portion of the structure of the two tables.

empdemo.dbf
pk_emp_id
fk_sex_id

sex.dbf
pk_sex_id
sex_desc (male or female)