>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)
So, just set up the combobox this way:
select sex_desc, pk_sex_id from sex into csrSex nofilter
RowSource = 'csrSex'
ControlWidth = "200,0"
BoundColumn = 2
Bound = .t.
ControlSource = v_employee.fk_sex_id
---------------------------
This is from the top of my head.
If it's not broken, fix it until it is.
My Blog