Parent/Child relationships

sibprogsistem
Thanks for your reply.
I checked the Owner table and I did not have the Cascade block checked.  For all my other trials I did check the box. So I must have missed it this last time.
.
Anyway, I checked the box and re-ran the program again.  But I still got the same result.
.
I'm afraid I don't know how to link the 2 tables.  I thought when I checked the Cascade Box in the Owner table that it would link the 2 tables automatically?  I wonder why that didn't happen?
.
After checking that box, I looked the at data in sqLiteStudio and it matches what is in your screenshot. 
.
Any thoughts on how to enable that link would be appreciated.
.
Thanks, Frank

Ahoy Frank!
Your understanding of how cascade-delete works is correct providing the cascade-delete option is ticked in your database schema (there is no separate link between the tables that needs to be maintained for the cascade-delete option - it's all done through the specified relationship between the tables).
The problem lies with the processing flow between your 'start' form and your 'frmmainmenu' form.
1.  Having created a vessel on the 'start' form, you move to the 'frmmainmenu' form using a 'show form' action rather than a 'create record' (or 'show record') action. 
2.  This means that you are not passing the vessel-id through to the form where you then add an owner.  Consequently, when you add an owner, it isn't related to any vessel. 
3.  You can see this in frmmainmenu.tblgridowner by adding the vessel to the grid - the vessel_name column is blank. 
So when you do a 'cascade-delete' of the vessel, the program deletes the vessel but doesn't have any RELATED owners to also remove (you can confirm this in your actual project by looking at the raw data using something like SQLiteStudio or create a temporary form to dump all the data on so you can check it).
You could simply add a combobox to frmmainmenu to select a vessel and then remind the user if no vessel has been assigned to the user if it's left blank (see attached) although it's probably not the way that I'd choose (but neither do I know the details of your project).
Derek.

Derek,
I took a quick look and changed my to Main Menu button from Show Form to Show Record and it looks like that may have fixed my problem.
.
I'll do some more experimenting later today to make sure I'm doing things correctly.
.
I did not know the significance between Show Form and Show Record before now.  I must have been lucky with some of my earlier work.
.
When I get to watch the video from sibprogsistem later today, I'm guessing his example will probably show me the same thing.
.
Thanks for your help
Frank

Hi Frank,

I'm only guessing here but are you trying it  with data created AFTER you made the appropriate changes or BEFORE?  If it's data from before, then 'cascade/delete' still won't work because the relationships still aren't in place that enable MVD to 'cascade' down through the data (changing the program isn't going to retro-fix any old data).

Again, a guess;  this sounds like
1.  the start tablegrid isn't set to 'show all records from the table' (see screenshot)
or
2.  you've got a 'search' button that you need to click (either manually or by script) when the program first runs.
If you attach your program, I could say with more certainty - as it is, it's more a case of 'it sounds like'!
Derek.