I am trying to come up with a solution to have a window pop up on commit of a specific field.
I have a table
Once a persons Member ID has been entered/committed to the MemberID field I am trying to have one of two things happen.
At the minimal I would like a window to pop up to show all the entries in the table for that persons MemberID.
Ideally I would like to create a script which would eliminate double entries into the table based on the new entry's MemberID, Quarter, and Year. Meaning if the MemberID (person) has already paid 4 quarters in a given year a warning would pop up.
Member John Kennedy has already paid 1st thru 4th quarter of 2018 if an entry was being made again for the same John Kennedy for the year 2018 an alert would appear.
Thanks as always.