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);
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.