D
Dana809904
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.