>>Do you allow or not duplicates in that field? Maybe your problem arise from the fact that there is some duplicate but deleted records. ITC, put a filter on NOT Deleted() on your candidate index.

---

>Well, that won't work. There's duplicate values so it won't let me make it a candidate key.
>
>
>According to the legacy code I'm redoing, there's not supposed to be duplicates. Which would make sense since the field is a serial number. But I just did a query and there's 103 of them with duplicates and they're not deleted, either.

Michelle, PMFJI, but aren't you going to remove your dups? You really should have a candidate index on the field to back up your code.

Peter Robinson