470,644 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,644 developers. It's quick & easy.

displaying the data of three tables in one form

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
b. making a combination query of all three and making one form of all of

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

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
Nov 13 '05 #1
0 1672

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Neil Ginsberg | last post: by
15 posts views Thread by Bo Diddly | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.