Widow / Orphan Protection for Records in Microsoft Access - Prevent 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? BONUS FOR MEMBERS: Silver Members and up get access to an Extended Cut of this video. 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. MEMBERS VIDEO: https://youtu.be/cmvLEJaioyY​ BECOME A MEMBER: YouTube: https://youtube.com/channel/UCl7-jJie...​ or My Site: https://599cd.com/THMember​ LEARN MORE: https://599cd.com/WidowOrphan​ LINKS: Invoicing: https://599cd.com/Invoicing​ Missing Data: https://599cd.com/OuterJoin​ Relationships: https://599cd.com/Relationship​ Don't Delete Data: https://599cd.com/DontDelete​ Cascade Delete: https://599cd.com/CascadeDelete​ Copy an Order w Details: https://599cd.com/ACD24​ COURSES: FREE Access Beginner Level 1: https://599cd.com/Free1​ $1 Access Level 2: https://599cd.com/1Dollar​ FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree​ Blank Template: https://599cd.com/Blank​ Contact Management: https://599cd.com/Contacts​ Order Entry & Invoicing: https://599cd.com/Invoicing​ More Access Templates: https://599cd.com/AccessTemplates​ ADDITIONAL RESOURCES: Get on my Mailing List: https://599cd.com/YTML​ TechHelp: https://599cd.com/TechHelp​ Consulting Help: https://599cd.com/Consulting​ Twitter: https://twitter.com/LearningAccess​ https://en.wikipedia.org/wiki/Microso...​ https://products.office.com/en-us/access​ https://microsoft.com/en-us/microsoft...​ Email Me: amicron@gmail.com KEYWORDS: microsoft access, ms access, #msaccess​, #microsoftaccess​, #help​, #howto​, #tutorial​, #instruction​, #learn​, #lesson​, #training​, #database​, widow, orphan, referential integrity, prevent missing parent, entry into subform, relationships, related subform QUESTIONS: Please feel free to post your questions or comments below. Thanks.