Widows & Orphans
By Richard Rost 3 years ago
Widow / Orphan Protection, Prevent Missing Data
Learn how to prevent orphaned records in your Microsoft Access databases. These are records on the "child" side of a relationship that are missing a parent.
Alaina from Seattle, Washington (a Platinum Member) asks: I'm working with your TechHelp Free Template (thank you, by the way) and I've noticed that it's possible for a user to enter order detail items without having first created an order. This causes them to be lost in Limbo. How can I prevent this?
Members will learn how to prevent widows, which are parent records that have no children. If you want to force a user to enter line items in an order before allowing the order to be saved, use this technique.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Widows & Orphans
Get notifications when this page is updated