Easy Form/Lookup Question

R

RBr

This is probaby easy, and I am missing something simple - so any help,
or on-line tutorial is welcomed.

I am trying to mess with the Contacts db that comes with Access. I
have Contacts, ContactType (Customer, Business, etc), and
ContactTypeStore.
- Contacts has just personal info
- ContactType has two fields (AutoNumber, ContactType [text])
- ContactTypeStore has two fields (ContactNumber [from Contacts
table], and ContactTypeNumber [the AutoNumber from ContactType).

On the form, I want to have a drop down where I can select "Customer",
and in the ContactTypeStore table the Contacts.ContactNumber and
ContactType.AutoNumber will be entered into the ContactTypeStore table.

Thanks!!!
 
Top