>I got it again even with SET EXCLUSIVE OFF on replace mNotes with m.lcString in Load_Trans command.
>
>I'll get new copy of data and will resume my tests.
Naomi - I had that a long time ago - I forget what I did, but, try this,
1) open your DBF
2) delete all the tags (delete tag (mytagname))
3) SORT on the primary or most used look up field or fields to a temp dbf (set dele on so deleted records will be ignored) - make your physical order your primary order.
4) ZAP your "permant" DBF
5) APpend your tmp dbf to it
6) index each tag
Is it a local DBF - or on a server someplace?
Imagination is more important than knowledge