518
Hello all,
Want to create a validation if a record is already exist in a table.
and also how to check if the record already exist in a table.
Thank You
Siddhant
*This post is locked for comments
I have the same question (0)
Your table should have a unique index (AllowDuplicates:No) that contains the fields that define the uniqueness in this table.
Once such index is in place, the system prevents you from inserting duplicates into the table.
If you want to check if a record exists, you should develop a method called "exist" which takes the unique index fields as parameters, and returns if such record exists or not. You can find plenty of examples in standard tables such as CustTable.
Share
Report
All responses (
Answers (
