One form to update multiple tables

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

Guest

I'm trying to create a form that will update seven tables. The form is
linked to our mailing list, but the mailing list is made up of data from the
six other tables. I have check boxes on the form (with a subform or linked
field for any category specific data) that indicate where the data belongs in
addition to the main mailing list (Ie. if someone is a prize winner, a
volunteer, and a PI member I need the information to appear in each
corresponding table as well as in the mailing list. Also, When I created the
form from the mailing list table only 300-odd of 800-odd records appear,
which correspond to the number of PI members) How can I get all the records
to show when scrolling through the form?

I apologize for my difficulty in explaining my problem. I think my solution
will require programming of some sort, but I'll need a walkthrough if so, my
programming skills are very limited.

Thanks in advance for any help that might be offered!
Vireyda
 
I'm trying to create a form that will update seven tables. The form is
linked to our mailing list, but the mailing list is made up of data from the
six other tables. I have check boxes on the form (with a subform or linked
field for any category specific data) that indicate where the data belongs in
addition to the main mailing list (Ie. if someone is a prize winner, a
volunteer, and a PI member I need the information to appear in each
corresponding table as well as in the mailing list. Also, When I created the
form from the mailing list table only 300-odd of 800-odd records appear,
which correspond to the number of PI members) How can I get all the records
to show when scrolling through the form?

I apologize for my difficulty in explaining my problem. I think my solution
will require programming of some sort, but I'll need a walkthrough if so, my
programming skills are very limited.
Click to expand...

I really think your solution will require instead that you rethink
your data structure!

Having seven identically structured mailing list tables and storing
data redundantly in the tables is *incorrect design* and will be a
source of unending trouble.

You should have ONE mailinglist table, containing all of the names and
addresses. This table could be related to one or more other tables;
for example, if you have prize winners you might have two additional
tables:

Prizes
PrizeID
PrizeName
Description
DateAwarded
<other info about the prize>

Winners
PersonID ' link to the mailing list
PrizeID ' link to prizes

To generate a mailing to just those people who won the No Bell Prize
(don't knock it! just ring the doorbell <g>) you could create a Query
joining the three tables, with a criterion on "PrizeName" of "No Bell
Prize".


John W. Vinson[MVP]
 
Back
Top