Hi,
How to check for Duplicate record while saving in Modal Form.
Need to check whether the same combination exists while saving, if so need to populate Error message and force user to change accordingly
Please advise
Regards
Arun
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Thanks, That worked for me
You can create validations on individual fields to check if that already exists. But if you need to check on a combination of fields, you can do this by creating a process before the form process. Follow these steps:
Click on the process tab and then create a process and put it before for the form save process. Then you can add your PL/SQL code to check if a record exists. The following is an example:
This will not allow the save until the error is resolved.