penfold1992
Registered User.
- Local time
- Today, 20:17
- Joined
- Nov 22, 2012
- Messages
- 169
I have a main form which requires users to fill in their ID number in order to create a new entry into the database.
ID numbers are stored in a table that has two columns:
ID Name
This is so that I can match up the ID to their name when they enter in a new entry. I currently have a normal drop down where you can select something from the "ID" column in the table however I wonder if there is a possibility to show the second column as well for a reference... ill give an example of what I would like the drop down box to look like
(ID) - (Name)
274 - John Doe
275 - Jane Doe
276 - Karl Brahms
277 - David Augsi
278 - Sandra Haston
when someone enters one of these, it enters just the ID number into the database entry, the name is just there aesteticly. Is this possible to do or too complicated?
ID numbers are stored in a table that has two columns:
ID Name
This is so that I can match up the ID to their name when they enter in a new entry. I currently have a normal drop down where you can select something from the "ID" column in the table however I wonder if there is a possibility to show the second column as well for a reference... ill give an example of what I would like the drop down box to look like
(ID) - (Name)
274 - John Doe
275 - Jane Doe
276 - Karl Brahms
277 - David Augsi
278 - Sandra Haston
when someone enters one of these, it enters just the ID number into the database entry, the name is just there aesteticly. Is this possible to do or too complicated?