Good morning FileMakers,
I have a field, we'll call it FIELD. I allow duplicate values in this and I would like to create another field ( DUP_COUNTER ) that is a serial number that increments up one everytime a duplicate value is entered. I'd like to do this in a calculation or an auto-enter rather than during an open script or script trigger.
I'm using FM 17 on a mac and hosted on 17 Server as well.
Let me know if anyone has any ideas.