Hi Peter.

>I want to index one field that is always used in the CREATE TABLE but needs to allow duplicates. The only way I have been able to do this, thus far, is to issue an INDEX fldname TO indexname command AFTER the CREATE TABLE... am I missing something here?

No, that's the correct way to do it. The only kind of indexes you can create with CREATE TABLE are primary, candidate, and regular but as a foreign key to another table.

Doug