G
Guest
Hello,
I am hoping somebody can help get me started or at least point me in the
right direction as I am rather new at the more complex database
administration.
I have a contact information database with a Seminar scheduler and also a
Mailings table to keep track of mailings that go out. I am trying to insert a
series of new records to the mailng table from a form where the individual
contacts(from an individual table) match up with the key value(via foreign
key of course) of a selected entry in a comboBox. I am envisioning this
process being kicked off with the onClick event of a command button.
Basically a record set of individuals will need to be generated that matches
the particular value in the combobox. Then I need to run a loop that enters
a new record in the mailing table for each matching
individual.
I have not had any trouble inserting new records with the use of the form.
However now I would like to take the navigational functionality away from the
form and use it solely for this "batch record insertion".
I would GREATLY appreciate any assistance on this task, as I have people
anxiously waiting on a functional version of this database!
Thank you very much in advance and please let me know if you need any more
info,
Dana S.
I am hoping somebody can help get me started or at least point me in the
right direction as I am rather new at the more complex database
administration.
I have a contact information database with a Seminar scheduler and also a
Mailings table to keep track of mailings that go out. I am trying to insert a
series of new records to the mailng table from a form where the individual
contacts(from an individual table) match up with the key value(via foreign
key of course) of a selected entry in a comboBox. I am envisioning this
process being kicked off with the onClick event of a command button.
Basically a record set of individuals will need to be generated that matches
the particular value in the combobox. Then I need to run a loop that enters
a new record in the mailing table for each matching
individual.
I have not had any trouble inserting new records with the use of the form.
However now I would like to take the navigational functionality away from the
form and use it solely for this "batch record insertion".
I would GREATLY appreciate any assistance on this task, as I have people
anxiously waiting on a functional version of this database!
Thank you very much in advance and please let me know if you need any more
info,
Dana S.