> FK is tied to master tables ID field, cascade in update and delete.
> Should I put anything into Keylinks and KeyDescLinks?

(Ignore KeyDescLinks - thats mostly for lookups).

I would try putting putting the PK fields in the KeyLinks and turning
KeyLinksAutoDefine off - just to see if it makes any difference.
Actually, I think you can probably tell from the SQL Monitor whether
IBO is properly detecting the primary key details for the detail table
but its probably worth a shot anyway. (if only because I cant think
of much else right now ;-)

> Is there troubles with foreign key?

I dont think so. I've had setups like this before and not had
problems. Although I have never used keylinksautodefine, I've always
explicitly defined the required KeyLinks.


You said this was an intermittent problems so I guess its not
practical to leave the SQL monitor turned on till it happes. Pity,
that could be revealing.


Geoff Worboys
Telesis Computing