Combo box referencing the wrong column

Poindexter

Registered User.
Local time
Yesterday, 20:41
Joined
Nov 14, 2008
Messages
14
I am using a form to enter data into Table 1. The form has various combo boxes that allow the user to select infromation from a list, contained in Table 2. However, when I look at Table 1 I noticed that the ID field from Table 2 is appearing in the field where I expected the information I selected in the combo box to be.
I was wondering if there is away I tell it to add the data in the combo bow rather than the ID field?
Or, is it better to do this by linking the tables in a query? I know how to do this but it just seems like an extra step.
 
What you have sounds like correct design. Linking the tables in a query is what I would do. Otherwise, why have an ID field at all?
 

Users who are viewing this thread

Back
Top Bottom