Cascade Delete

[lmcc007]

I might store the notes in another table if it is a memo field (keeps corruption from happening so much). But the rest should be fine together as long as there will only be one attachment path per record.

Hi boblarson,

I did this but I am having trouble when I delete a Note it leaves a blank/empty field in the EventNote table. I added a delete button to the EventNote form, but when it deletes it deletes the Event information instead of just deleting the Note.

Did I set up the EventNote table correctly?

I attached the db.