I have 3 tables; Contacts, Affiliations and Donations. (All related through a ContactID field.)
I have portals (in popover windows) on the Contacts home page showing affiliations and donations for that particular contact.
I have a separate popover window that creates a new affiliation using global fields. All that works fine.
However I want to make sure each contact has no more that one affiliation per year. Is there a way to do that? I would like to perform the check before I commit the record, but am not sure I can do that.
Here is the script to create New Affiliation