How to take a record set from one table and insert it into another table?
Posted on 2010-09-08
I have a marketing application that is to do the following:
User picks from a data entry form an Issue Name (Calendar 2010 for example) and a Mailing List (Contractors for example). Calendar 2010 is IssueID 1 and the Contractors Mailing List should query the ContactsView for all records where Contact_Type = 'Contractor'. Let's say there are 200 records that are 'Contractor' records. Now what I want to do when the user picks these 2 items and clicks a button called 'Export' is that each of those records in the ContactsView that matched the Mailing List (200 records) be added to a table called 'MarketingHistory' where it saves the ContactID, address fields and email address of the contacts as well as the IssueID of 1. I just need it to save the contact records that belong in the mailing list (per a query) as well as the IssueID and put them in as new records into the MarketingHistory table.