easiest:

set deleted on
set order to jobnumber
go top
scan
  scatter memvar jobnumber
  skip
  if jobnumber = m.jobnumber
    delete
  endif
  skip -1
endscan

better way is to have job number automatically built by a stored procedure when adding a record to the table. if coded correctly, eliminates possibility of duplicate records.


>Using a job number, there are 2 records being created.
>Thanks
>
>
>>>vfp 3.0 and win 95
>>>
>>>I would like some suggestions for writing some
>>>code to delete duplicate records that are created
>>>on append and insert.
>>>
>>>I am working with clipper dbf files and have tried
>>>literally everyway possible to prevent it from happening.
>>>
>>>Any thoughts?
>>>
>>>Thanks and have a good day!
>>>
>>>Becky
>>
>>are they completely identical or are you trying to eliminate recs w/ same name...