Master Detail problems

From: Marius Minnen (m.minnen_at_chello.nl)
Date: 10/16/04 

Date: 16 Oct 2004 09:53:10 -0700

Hello,

I've got three tables linked by means of a master detail relationship. The data from the tables is shown to the user with three DBGrids. When I select a new record in the master table the other two tables usually change too to reflect the change in the master. But on occasion I am getting a "Type mismatch error" (EOLEException) when I change to another record (happens at random so it appears, different occasion and different record all the time). After this error occurs the detail table only shows the first record associated with the master table in the DBGrid. When I restart the program everything is fine again. Anyone have any idea what may cause this behavior?

Cheers,

MJM Minnen