Using Combo Box Like a Text Box Lookup

[dpetet]

First time poster on the board, please be patient. Years of Access use but still feel like a novice at times...

"EmplJobs" is a simple table with 7 fields: EmployeeID, JobCode, JobeCode1, JobCode2... thru JobCode5

Trying to create a form with a main ComboBox to lookup employees in "EmplJobs" ands return what is currently in the fields "JobCode(s)". I want to show what is in those fields in six ComboBoxes BUT with the ability to edit and update using the pull-down data from another table.

The problem - I want 6 ComboBoxes on the same form that use a 3rd table "JobLookup" as the pull down list reference. But when the user chooses a new line, I want it to write that back to the table "EmplJobs".

This seems like it should be simple - maybe my approach is just flat wrong.

Can a ComboBox be used like a text box lookup, but reference another table for the pull down list? Once chosen, can the value be written back to the control table?

 

[RuralGuy]

You probably do not want to hear this but when I see table descriptions like: ""EmplJobs" is a simple table with 7 fields: EmployeeID, JobCode, JobeCode1, JobCode2... thru JobCode5" alarms start going off about normalization. You may have an issue with your design that may make every task just that much more difficult.