AnsweredAssumed Answered

Newsletter subscription management via FM 15 Pro Advanced - stuck on list of issues per subscriber

Question asked by argoron on Jan 22, 2017
Latest reply on Jan 23, 2017 by philmodjunk

I am trying to manage subscriptions and distribution of newsletter issues via FM 15 Pro Advanced.

The problem I'm facing is on the following point: inside the layout for each subscriber I'd like to include a list of all published newsletter issues,
and see whether the subscriber has received or not each individual issue.

 

I have three tables - Subscribers, Issues and Mailings. The latter is a join table between Subscribers and Issues and has the following fields:

  • SubscriberID (link to Subscribers);
  • IssueID (link to Issues);
  • MailingDate

That table will give me the issues that the subscriber has already received, but I do not know how to also get hold of the issues the subscriber has not yet received. I'm quite new to FM and any help on this would be greatly appreciated.

Outcomes