AnsweredAssumed Answered

Assign specific record to a contact

Question asked by ultranix on Jul 26, 2012
Latest reply on Jul 26, 2012 by JimMac


Assign specific record to a contact


I am preparing a module in which I could track whether or not I sent my contacts (CONTACTS table) monthly newsletter.

For that matter I created a table NEWSLETTER of 3 fields: Date, Text (Text of sent newsletter), status (replied, unreplied, called, etc.).

Not all of my contacts are receiving that newsletter, only those, whose rating is B and above (A, A+).

The main purposes of the module are basically two: 1) ability to know who received what and when 2) ability to count newsletters sent on each occurence (on every record entry in NEWSLETTER table).

How do i set up database and link everything in order to achieve desired results?