INSERT records within a SELECTED set

[Guest]

First, I am not an Access lingo person so please forgive me if I do not use
the correct terminology. My apologize to all who are well-versed.

I need to INSERT records into into multiple tables that can be driven from a
SELECTED SET from one single table.

Specifics:
======
Table of Sponsors contains a one-to-many link to Table of Entities.
Sponsors contains a one-to-many link to Table of Payment Records.
Table of Payment Records contains a one-to-many link to Table of Allocations
(bucket for periods).

A sponsor sends a donation for one or more entities that are related ONLY to
that sponsor.

I need to INSERT into the Allocation table a record for each Entity (in
preset specified amounts, e.i: $20 or $40 depending on Entity type).

I have been using a Form and manually entering in the data but that is
toooooo time consuming when you have somebody donating for 13 months at $20
per Entity.

Can sombody help in getting me pointed in the right direction? I would like
to have it done automatically for me with minimal inputs from me!

Thanks

 

[Arvin Meyer [MVP]]

If you post the names of pertinent fields in the tables, we should be able
to write either a query, or code to do that for you.