[DUG] Relationship or not

[Marshland Engineering]

This is more on guidance rather than a solution. I'm using MySql with many
tables with no SQL Linking. Most data was referenced from data in tables. Over
time, some of my data has
been scrambled and I have a few records in child databases with no parents. 

I downloaded dbForge and started looking at linking the tables with parent
child relationships to try and fix this. Once I started running my app, I got
crashes all over the place. Not in edit mode. 

In the past, I had grids on the main page and all editing was done on child
forms. On going into the form, I set edit on and on exiting, posted the data. 
All worked.

Now with relationships on as defined in the database diagram, the app is
crashing. Without too much investigation at this point, it looks like
background updates are happening at times when tables are not in edit mode. It
gives me an error on just returning to the parent form and not on a database
access
line.  Short of always having the tables in edit mode, I have 2 options, leave
off all external SQL table relationships and do more coding in Delphi to check
for data integrity or use relationships and find a better way of making it all
work.    

Any suggestions ? 

Thanks Wallace.   03 3237449