Linking Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, so I have a products table (tblProducts) and a contacts table
(tblContacts). I have a primary key of an autonumber (atnContactID) on
tblContacts that is linked to the field Contact ID (intContactID) on
tblProducts. I then set intContactID as a combo box tied to atnContactID.

So...when I went into tblProducts I can now select the ID from the dropdown.
Trouble is when I'm in a form I can't see the name of the contact which is
what I want...I could care less about the ID as it isn't used for anything.
Any open suggestions on what I should do (or should re-do)?

Thank you!!! You guys rock.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code problem 5
Primary key in every table? 1
Find Method on Unbound Form Help 4
Access Control on subform / combo box requesting parameter 0
how to use many to many join in a database 1
Entry of primary key data 11
Using Collect Data with Related Tables 3
Order entry 5

Back
Top