Dear experts -
Sorry for the provocative title!
I was having major issues with cascading deletes in a form, so I made some changes to the recordset as well as removed ALL relational integrity enforcement/cascading deletes in the Relationships setup for the back-end.
The problem is gone.
However, I'm wondering now about the macro questions - do I need the Relational Integrity checking? Can you have a good relational database in Access just using the native forms/subforms without it?
Can you please lay out the arguments pro/con?
I know it's both a basic and a big question.
Thanks so much -