I am using the indexseek() command to check for duplicate records. Currently, I have a deleted record with a field value of 'C'. I have another record that is not deleted and has a field value of 'C1'. If I rename 'C1' to 'C' the indexseek() command causes the deleted record to be found. Can somebody tell me why this happens and how to get around the problem?

I have set delete='off' and set exact='on'.

Thanks,

Lance