Page 1 of 1

Check duplicate not working

Posted: Sun May 01, 2022 6:13 am
by crash

I'm trying to prevent a duplicate record. My field updates as an auto-update from the user.
I've ticked the Check Duplicate box... but it still adds in the field from the autoupdate.

How do I set this that it will tell the user there is a duplicate record.
There are no tips in the help file... even under Row_UpdateConflict

Any help please.
Thanks


Re: Check duplicate not working

Posted: Sun May 01, 2022 7:56 am
by MichaelG

Auto-Update Values are not checked for duplicate. You can add your checking in Row_Inserting / Row_Updating server events.

If you write your own AutoUpdate method, you should make sure the value is unique.