Duplicacy Problem-

naushie

Well my problem id like this.
I have table service item 5940.In this table the primary key is "No." field.
and this table has one more field called "serial no."
since primary key is the "No." field so we cant have two records of the same "no.".
But what i want is the "serial no." field should also be unique in the table.
now can any one tell me how can i do it.
my main aim is to stop user entering same "serial no" again.

please suggest some one how can i do it.

FPulsfort

You have to programm it in the OnValidate-Trigger of the field "Serial no.". Make a variable of type record and subtype "Service item". Then search with setrange for the entered serial no. If you find a record give an error-message.

Hope this helps.

Regards,
Frank

naushie

hi
i have done it thanks for the suggestion.