I have a combobox setup with:
rowsourcetype=SQL
rowsource=SELECT descr FROM jobs
(the combobox is populated with available JOBS.descr)

JOBS is a look-up table with 2 fields: descr & code.
I have another table called myTable, with a field called myTable.JobCode.
(JOBS is a lookup table for myTable.jobcode).

How do I set up the controlsource property (& any other properties) so that the combobox shows/displays corresponding JOBS.descr (instead of myTable.jobCode) when the form is showing a record from myTable?

When user selects another JOBS.descr from the combobox, I'd like JOBS.code to be written to myTable.Jobcode.

How do I set up the controlsource / boundcolumn / .... ???
THANKS ALL!