Relationship or not

[Wallace Weideman]

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

I downloaded Workbench 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. Message - 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 specific 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.

What are your thoughts ??