C
Cheech73
I have three tables for a magazine application:
Advertisers (they get subscriber leads in the form of demographic info)
Contacts (they are the leads - name, address here)
Calls (tracks the calls made to the Contacts, records demographics)
Advertisers may select to recieve their leads in either print form or via
e-mail. Advertisers are assigned their own Reader Service numbers for the
year as well as hypo category numbers of related products/services.
In the Advertiser's data entry form I have included a yes/no that you can
click to determine which method has been requested. Leads may request
information from more than one advertiser, and some advertisers may fall
under the same hypo category. That is why I did not put this option under
Contacts or Calls.
I am trying to write a query that would take the demographics from the Calls
and Contacts forms and ask the Advertiser table what advertisers want e-mail
or print leads and run them each separately. For example, John may want more
information on Florida and New Jersey. The advertiser for New Jersey wants
printed leads, and the advertiser for Florida wants e-mail leads. I want to
have that lead (and any others who selected that product or location) pop out
in both places in the appropriate method.
Any ideas to better manage this, or link to a similar DB?
Thank you
Advertisers (they get subscriber leads in the form of demographic info)
Contacts (they are the leads - name, address here)
Calls (tracks the calls made to the Contacts, records demographics)
Advertisers may select to recieve their leads in either print form or via
e-mail. Advertisers are assigned their own Reader Service numbers for the
year as well as hypo category numbers of related products/services.
In the Advertiser's data entry form I have included a yes/no that you can
click to determine which method has been requested. Leads may request
information from more than one advertiser, and some advertisers may fall
under the same hypo category. That is why I did not put this option under
Contacts or Calls.
I am trying to write a query that would take the demographics from the Calls
and Contacts forms and ask the Advertiser table what advertisers want e-mail
or print leads and run them each separately. For example, John may want more
information on Florida and New Jersey. The advertiser for New Jersey wants
printed leads, and the advertiser for Florida wants e-mail leads. I want to
have that lead (and any others who selected that product or location) pop out
in both places in the appropriate method.
Any ideas to better manage this, or link to a similar DB?
Thank you