I work for a nonprofit organization that allows individuals to sponsor children overseas. Some of these sponsors decide to become volunteers and speak at their church, university, or other event to find new sponsors. I am building an access 2000 database to store the results of these events.
I have a volunteers table with each person's name, contact info, and an id number. I then have a sponsorships table with the following fields:
id
fk_volunteerId (relationship defined)
date
sponsorName (the person who agreed to sponsor because of the presentation)
eventType (combo box with 5 set types)
Sometimes we will have nearly a hundred sponsorships come out of a single event, and I need a way for a nontechnical user to add sponsorships in bulk (a form basically), but I do not know any VB. Is there a built in function that I can use to do this or will I have to use VB? What I'm looking to do is build a form where the user specifies a volunteerId, an eventType, the event date, and the number of new records to be added and it will automatically insert that many records. (The sponsorName is not necessary in this case, if you were wondering.)
Thanks in advance!