>Optimistic row buffering, Vlad. For some reason the SEEK is calling the Referential Integrity code,

In row buffering, the triggers are fired each time you move the record pointer into a table. SEEK moves the pointer, so the RI code is called.

> and it's bombing at the client's site, although not on my system. I have a work-around now, but I'm concerned about the data. I'll suggest Glenn's total CDX re-build. And good backups.

You may also take a look to the RI code and see if it's correct (the one at the client site). Maybe somebody played with it and changed it.

A bad index can also brake the RI code, as Glenn already said.

Vlad