displaying the data of three tables in one form

[WindAndWaves]

Hi Gurus

Here is another question that I have been struggling with for over a year.

Basically, I would like to allow users to enter data into three tables in at
the same time. The reason it should all be happening on one form is that
the data comes in in chuncks and that the users do not like switching
between windows (forms) too many times.

To enter data into two tables (e.g. organisations and contacts) at the same
time (we are talking linked tables here) you can make a "single record form"
and a subform. Then, for example, the user can add a company GM and, in the
same form, add several contacts for GM.

Now, imagine that these contacts also bought goods from you and you needed
to enter this on the same form..... (sales table)

So, you have one organisation which links to many contacts, and one contact
who links to many sales items and we want to enter it all on one form.

Below I have noted some solutions that I have experimented with:

main options:
a. a main form with the company and a subform with the contacts and a button
next to each contact that opens a pop-up form where you enter any sales
made.
b. making a combination query of all three and making one form of all of
them.

Options that assume contacts only buy one good at the time:
a. a main form with the company and a subform with a query that combines
contacts and goods bought
b. a main form with the company and a subform with the contacts and several
unbound fields that "on insert" are added to the sales tables

As you can see, I have considered a number of different options but I would
be keen to hear what you think would work best. Any hints would be greatly
appreciated.

Thanks in advance. With greetings from the South Pacific

- Nicolaas

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 07/06/2004