Question: I have a table that contains a list of public records that I use for the purpose of mail merge campaigns. When a person replies to my marketing piece, I want to be able to a) transfer that information into a new table, b) delete the record from the original table and c) add additional information to the record via an interview with a form I set up for a phone questionaire. For me, the easiest point to do is (C) which would be to have a separate table for call ins for the additional information from the questionaire form. But how do I transfer the record from the one table to the other and how do I delete the record. Mind you, I want this to be automated tasks.
The reason for my thinking is that 1) I do not want to continue sending them marketing pieces if they called me already and 2) After a period of time, these records are going to be purged from my table anyway and I don't want my call ins or clients to be deleted altogether when step 2 is performed. Keep in mind that my business is foreclosure work and these records do have a shelf life. That's why they get purged over time
Thanks for the help