If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms entering unique ID instead of name, how to switch?
Hello! When a user enteres information on the form and submits it, the
database shows the unique ID number of the (for example) doctors name that was selected instead of the name itself. Why is this, and is there anyway to switch this around so when they select the doctor (from a dropdown), it actually inputs the doctors name instead of that ID number? Thanks! |
#2
|
|||
|
|||
Forms entering unique ID instead of name, how to switch?
On Thu, 21 Dec 2006 14:15:01 -0800, Sam
wrote: Hello! When a user enteres information on the form and submits it, the database shows the unique ID number of the (for example) doctors name that was selected instead of the name itself. Why is this, and is there anyway to switch this around so when they select the doctor (from a dropdown), it actually inputs the doctors name instead of that ID number? It's doing that because that's the CORRECT WAY TO DO IT. With a relational database, you store variable information - such as names - once, and once only (in the Doctors table for example). If you need information about a doctor in another table, you store the numeric DoctorID. If the doctor's name is changed (perhaps she got married), you can now change it once, and have the correct name displayed wherever you have a DoctorID stored. If you're assuming that table datasheets should display all the information in a human-readable way - lose that assumption. Tables are for data STORAGE, not for editing or data display - that's the function of Forms. And your form (with combo boxes) is evidently doing its job correctly! John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|