AnsweredAssumed Answered

Can a same table summary be displayed in a window?

Question asked by dennismoorejr on Feb 22, 2018
Latest reply on Feb 22, 2018 by philmodjunk

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

 

Transactions

 

with fields

 

MemberID

Payment Date

Payment Amount

Quarter

Year

 

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.

 

Example is

 

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.

Outcomes