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.