[Newbie] - Combo box and forms simple issue

[Sniipe]

Hey all,

I'm pretty new to MS access, but I have a form with a combo box.

Currently, visually everything happens as expected. The combo box pulls its value from another table, but when I click next record the current record outputs an error:

You must enter a value in the 'Employee/Course link table.employee_ID' field.

The field required for the table is an ID and not the acutaly employees firstname + surname as it appears in the drop down.

Any idea what I'm doing wrong?

 

[Sniipe]

got it. There is a combo box wizard in office 2007 and I just had to specify where I wanted to store that value.