Hi, I’m in the process of cleaning out a customers database in preparation for go-live and am carrying out a datbase test. Everything has been ok so far but when the test starts the Test Field Relationship stage it has a strange error. It is reporting that a record in the job table has an incorrect value in one of the fields that looks up to a User Defined table. This wouldn’t be a problem, except the job table is empty as is the table this fields is looking up to! If I click through a few of these errors it then tells me that Tabledata 0 does not exist. There was formerly a second company in this database but it has been deleted through the Delete Company routine so that shouldn’t be causing the problem. I have tried adding a new record into the job table with these values and deleting it. I have backed up and restored the database but it is still happening. Does anyone have any suggestions?? Thanks Stuart
Strange problem you have there. Try recompiling the object and related objects.