Not sure I understand exactly what you mean, but how about:

SELECT DISTINCT custtID, ... FROM... ORDER BY custid INTO TABLE...

Then zap the original and append the new table into it.

-Michelle


>Want to resequence my customer records, within customerid. Had a program bug that resulted in some sequence number gaps and duplicates. I first open cust.dbf and then order by custidseq. As I replace the sequence number, some records are bypassed.
>
>CustID Seq
>123 1
>123 1
>123 1
>123 2
>333 1
>333 2
>444 1
>
>When record #2 is resequenced to 2, then because of the custidseq order, record #3 is bypassed.
>
>What is a good way to requence?
>
>Brenda