By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

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

P: 1
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;
Dec 11 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,370
For proper data normalization, you should not store the name in the table. It is correct to store the id.
Dec 11 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.