3 customers to a form

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

Guest

How can I include 3 different customers and there different addresses/contact
info on the same form.
 
How can I include 3 different customers and there different addresses/contact
info on the same form.

Don't ask about the Form. Ask about your Tables!

A Form *doesn't contain any data*. It's just a window, a tool to edit
data in tables. Get the table design correct FIRST, and *then* worry
about forms.

In this case... if you have one <something> (you don't say what) to
three Customers relationship, you'll someday need *four* customers; or
in any case you'll want to be able to search for customers regardless
of whether they are the first, second or third. If so... you need *two
tables*; each customer should be in a separate record in the "many"
side table. You'ld use a Subform to enter one, or two, or three... or
as many as you need!... customers into this table.

John W. Vinson[MVP]
 

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

Back
Top