combo box value do not save expected values

[grenee]

Good Day all,

I have a combo box which is populated by a control wizard and gets its values from a field "CourseName" in a table "Course".
"CourseName" is of data type string value.

The control source of the Combo Box is a field "Course" in another table "timeTable"

The dropdown list displays the expected string values

However when one of these values are selected and automatically saved to "timetable", the value that is stored is the ID of the "Course" table and not the value in the dropdown box.

Can anyone explain and guide in correcting this problem?

 

[MarkK]

This doesn't sound like a problem. This is what I would expect to happen. Data should be linked by the ID value of the row in which it appears.