G
Guest
I have created a table of prospective customer records with an auto-generated
primary key. I also created a table for the purpose of maintaining detailed
information on mailings to selected prospects. The selected prospects are
retrieved via a query on the table of contacts using criteria. However, not
every query will result in a mailing.
Once I have created the query I ultimately want for the mailing, I’d like to
create a relationship between the contacts selected in the query and the
specific mailing. But I am unsure as to how to do it. Please note that not
every query will result in a mailing, there will be multiple mailings and any
given prospect could receive multiple mailings. Oh, and one more thing, when
I do subsequent queries, I’d like to see whether I have mailed anything to
them previously. Any ideas?
Many thanks.
primary key. I also created a table for the purpose of maintaining detailed
information on mailings to selected prospects. The selected prospects are
retrieved via a query on the table of contacts using criteria. However, not
every query will result in a mailing.
Once I have created the query I ultimately want for the mailing, I’d like to
create a relationship between the contacts selected in the query and the
specific mailing. But I am unsure as to how to do it. Please note that not
every query will result in a mailing, there will be multiple mailings and any
given prospect could receive multiple mailings. Oh, and one more thing, when
I do subsequent queries, I’d like to see whether I have mailed anything to
them previously. Any ideas?
Many thanks.