New Form Question - Linked Tables

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

Guest

I have 2 tables - Customer and Customer Contacts. There are often more than
one contact per customer. I want to create a form to enter new contacts. I
have the two tables set up in a query and I am thinking that I will use a
list box for the user to select which customer they want to add a contact
for. how can I ensure that they will select a customer name before moving on
to enter the contact name?
 
If this is a many-to-many relationship, then the contacts should be in a
subform.
 
Just to make sure I understand correctly. The customer name would be on the
main form and the contact info to enter would be on a subform?
 
You must log in or register to reply here.

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

Update Two Tables Using One Form Contents 0
Form Based on Query 3
append query if form item is null 0
OnClick on Combo Box opens a New Form 0
error 2489 1
AutoUpdate 3
How do I create mutiple orders in a subform linked to Customer ID? 2
Entering data with many to many relationship 1

Back
Top