Jet, your default database engine for Access, offers an option to turn on cascading updates when creating a relation object, often referred to as a relationship during database discussions. On first blush, this can seem like a good idea in many cases. I’ll discuss briefly here why that is not true. I’ll reserve comments on cascading deletes for another column. Continue reading
Everything should be made as simple as possible, but not simpler.