[archive] Paged List Box and Duplicate Keys

[Migrated content. Thread originally posted on 22 January 2007]

Has anyone ever found a way to correctly handle paged list box with a DUPLICATE KEY. The code examples work fine when the key is unique (primary key, etc). However, if the secondary key is a duplicate and there are indeed duplicate records in the file (many of them), the recommended code acts erratically.

I am beginning to think the best solution is to remake the file and eliminate the duplicate key by appending the primary key. That, of course, will require a file conversion, which postpones the fix to our next general release.