|
||||||
|
Parent Record By Richard Rost 20 months ago Adding a Parent Record if None Exists in Access In this Microsoft Access tutorial I will show you how to automatically add a parent record if the user tries to add a child record in a subform first thus preventing an orphan. We will automatically add an order record if the user starts adding an order detail record and the order doesn't exist yet. We will then set up Referential Integrity to prevent future orphan records if the user deletes the order. Pre-Requisites
Links
Recommended Courses
Updated TemplateSource Code
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, automatically add parent record, Check if Record Exists if not add it, Adding parent records, Preventing orphan records, Automatically adding parent records, Referential Integrity, prevent deletion
|
||||
| |||
Keywords: FastTips Access Fast Tips automatically add parent record, Check if Record Exists if not add it, Adding parent records, Preventing orphan records, Automatically adding parent records, Referential Integrity, prevent deletion PermaLink Creating a Parent Record in Microsoft Access |