Another Dumb question about adding record via form

[Steve]

This may be a dumb questions please forgive

I have a form that shows a list box that links to a table with 7
employee names
The form does not show employee key.
When adding record to master table I only need to add employee key.
So if I've entered a record for John Doe who has an employee key of 4.
How do I insert the number 4 into my master table?
The user selected John Doe in the box.

Does my question make since?

Thanks
Steve

[Roger]

On Oct 22, 12:48*pm, Steve <[e-mail]:

This may be a dumb questions please forgive

I have a form that shows a list box that links to a table with 7
employee names
The form does not show employee key.
When adding record to master table I only need to add employee key.
So if I've entered a record for John Doe who has an employee key of 4.
How do I insert the number 4 into my master table?
The user selected John Doe in the box.

Does my question make since?

Thanks
Steve

your listbox should have a recordSource that includes both the
employee key and name
and it should show 2 columns, with widths of 0";1"

this will show the name but will store the key in the field