How to make Name to Display when i select the Name form Combo box instant of ID

[bobo1990]

I have a problem with Combo Box

The Problem is i have my ID,Name in my Combo Box, If i select the name from Combo box. The ID will display in Table. But i don't want to see the ID in Table . I want Name to appear in Table. How can i do this . If you know please answer me as soon as possible. Because i'm in urgent to use this. So if someone know please reply me.

I have this as Row Source

SELECT Staff_Position. SP_Code, Staff_Position. SP_Name FROM Staff_Position;

[Rabbit]

For proper data normalization, you should not store the name in the table. It is correct to store the id.