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.
