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