3 customers to a form

S

Summit

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

John Vinson

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]
 
Top