The only problem is that it is sporadic, so it doesn't always happen. I am guessing that since this is the case, it can't be because of the foreign key...

-2147217871 Timeout Expired is the error message. We are running on a Windows NT platform with SQL Server 7.0.

Here is the table structure:

The problem is with the auddiofields table....