Delete Child Records on Delete of Parent Record
Greetings and thanks again for a great product.
I realize that we are not working in a truly normalized environment here so I have discovered that if I delete a record in a form (table) that has "child" records in another form, the child records are note deleted.
So I am trying to write an on delete script in the parent form to then delete the associated records in the child form.
Can you point me to some documentation for help with that? I can't find any function that lets me delete records in the code portion of the app (like fetch data...I then would want to delete each record that was in that data set.
Thanks in advance...
Joel