>thanks Naomi, may be problem, two sno, with same figure
Is SNO a char field or a numeric field? In any case, if you want SNO to be unique in your table, get rid of all the duplicates. The problem is - how would you know which record to leave and which to remove?
If your SNO is a non-unique field, do you somehow show user the record you are about to delete?
If yes and you're using VFP tables, then just use VFP command
select myTable
DELETE (assuming you're on the right record).
This way you would be certain which record you're deleting.
If you would need to get rid of the duplicates you may want to check FAQ #8129
If it's not broken, fix it until it is.
My Blog