Lee,

I think what I would do is convert all of the fields in the keyfield to one type
and store it in one field say of Char type. Then you would only have an primary
key index on one field.

OR

Does the text file have an added date or any kind of system date in it.
If so save the latest date when appending and only append the records
that are greater then that date the next time.

hope this helps

Jeff Whitaker

>This works, but since the keyfield is actually a combination of several different typed fields, it requires a complex index and relation that is problematic. My question is this : Is there a way of using a select statement to select just the new items to be added.