Hi,
Can anyone pls let me know how to check if the particular field value for example a claim number entered on the form is unique ?
Nowhere in the database, this claim number should be the same as the one entered.
Hope i can write some coding in the Input validation formula of the field, can u pls let me know if I can go for Formula language or lotus script…and how to proceed with the code?
Thnx…
Subject: How to check if a particular field value is unique(comparing to the other values already entered in the database) ?
Hi Gayathri,
First create a view which lists all the claim number. The claim number should be the first column of the view and sorted ascending.
In the querysave event do a validation to check if the current claim number is already present in this view. If so do not allow to continue.
Hope that should help.
Regards
Javed