Hi Chuck.

>I didn't DELETE TAG ALL. What I did was change the index type (Regular, etc) and also, used UPPER(blah) for every index (because weird things happens if not in upper case). Could that have wiped out the RI?

Persistent relations are set up in the Database Designer by dragging from the primary index of a parent table to the appropriate index of a child table, or programmatically using ALTER TABLE on the child table. If you don't have a primary index for the parent table any more, you can't create persistent relations for it.

Doug