Simon Evans said:
I am trying to get it so that if someone pledges £5 on one table then with
a click of a button 5 tickets are added to another table linked to the
person.
Your question is a little sparse on details - table and field names, etc.
However, generally there would be no point in creating 5 related records if
all you needed to do was print the tickets. For example, if I had a table
of sponsors:
tblSponsor:
FirstName
LastName
TotalAmount
....etc
Then I could use this structure to print the correct number of tickets,
using either VBA code or, at a push, using a 'helper table' and any avoid
coding.
The only time I might be convinced of the need to add records to another
table would be if I had to keep a record of each ticket, its number or other
tracking details. If this is the case, you can do it but you need to
provide more details.
