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