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?