>I am creating a cursor with keyID = 'key_value' from joining several SQL tables and each SQL table has keyID and keyIncrement as fields. When the cursor is created, it has several duplicated keyIncrement records for the given key_value. Then, I create an index as "INDEX ON STR(keyID)+STR(keyIncrement) TAG idx_MAD OF cdxMembers UNIQUE" to eliminate the duplicate increment numbers. ....

Hi Kay,

Exactly what SQL are you using? How are the keys being duplicated? Does some table have several matching rows that causes the duplicates in the result set? If there are several matchine key combinations, what about the rest of the fields? If they differ, how do you know which values you want to use/

Using a Fox UNIQUE index has always been a bad idea.