I believe it is a problem with relationship,
what I have been trying to do is
each customer is assigned the new Volume but I dont want to use a drop down menu to assign each subscriber.
When i add a new volume newspaper i want it to automatically assign everyone the volume and it is listed in the portal for each customer/subscriber
Customers::LinkIDfk - Newspaper 2::LinkIDfk list all of the volumes for each subscriber but i am stuck on how to set it up, when I add new Volumes it is assigned to all subscribers so I can email the new volume to subscribers.
If you are on a layout based on Customers when you send the email, your NewsPaper 2::VolNumber & "¶" & " Please use this link to View PDF " & NewsPaper 2::WebLink calculation will refer to the first related record in NewsPaper 2.
You need to either set up a new relationship to NewsPaper or modify the existing one to sort the relationship by VolNumber such that the first related record is your most recent record. If VolNumber is a field of type number, you can sort your relationship by VolNumber in Descending order to put the most recent record first. To specify a sorted relationship, double click the relationship line between Customers and newpaper 2 to open a dialog where you'll find an option for sorting Newspaper 2.