>GOT IT!!! Goes to show that if you leave something for a couple of
>months, your memory begins to fade... Problem being the table is indexed
>on the response_id field. How could I miss that?? After posting the
>message, I did find out that the table was supposed to be contained in a
>DBC. When the table was freed, the response_id field name was shortened to
>10 chars. Thank you for kicking me in the head and waking me up..... :-)
Getting it in the head from us is far easier than hitting it against a
wall. Once I got that message I played around it all day, though I knew
the cause (can imagine you not knowing it at the time).
I've seen a worse scenario, with free tables:
Use table1 order codefield
sele 0
use table2
set rela to codefield into table1
index on table1.namefield tag name
close data all
use table2
This is pretty unstable, but it did work, provided both tables were
opened using the first four lines. It crashed only if someone not
knowing it tried to open the table2 without opening table1 and setting
the relation.