[quote user="Avinash B"]
On the OnValidate trigger of the field, filter the records with the value entered. If found then throw error.
In your case, OnValidate trigger of "Identification No." you can write the following code.
trigger OnValidate()
{
Var
Employee: Record Employee
begin
Employee.Setrange("Identification No.", Identification No.");
Employee.SetFilter("No.",'<>%1',"No.");
If Employee.FindFirst() then
Error('The Identification No. must be unique');
end
}
This might help.
Regards,
Avinash B
[/quote]
The code above works, but i suggest you to optimize it. Instead of using FindFirst(), make the if statement like this: if not Employee.IsEmpty() then
