• Registered: 2017-11-20
  • Posts: 103

Topic: How to handle unique data in the button's new record action.

Hello again, is there a way to do this?
1- I want to cancel the insertion of a data to the database if it already exists (eg the identification number of the person, ID), that is, when I click on a save button if the data exists, I get a message  and do not insert this data because it is repeated.

I am using 6.5 version

2 Reply by ehwagner (edited by ehwagner 2021-02-23 22:47:43)

  • Registered: 2015-11-13
  • Posts: 652

Re: How to handle unique data in the button's new record action.

wenchester21,
I put together the attached example for someone else on the forum in the past. It includes not only new action duplicates, but if the user also tries to change the info which would also cause a duplicate. See if it is workable for you.

Post's attachments

Attachment icon Dup Check.zip 338.99 kb, 269 downloads since 2021-02-23