Uploaded November 2026 | Updated November 2026, 3 hours ago
In this lesson, we will continue organizing inventory in Microsoft Access by creating table relationships and enforcing referential integrity. We will discuss cascade deletes, build an inventory search query with a wildcard parameter prompt, and create nested continuous subforms for locations, areas, subdivisions, and items so you can browse and enter inventory records within the hierarchy.
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will learn how to build a dedicated inventory entry form using reverse cascading combo boxes. I'll show you how to use Access's built-in cascading combo box features, use a small amount of VBA to reverse-cascade from an item's subdivision to its area and location, and use the older SQL-based method for manually filling the combo boxes. We will also keep the selected location and area values when entering multiple items in the same place.
MEMBERS-ONLY EXTENDED CUT VIDEO:
youtu.be/XTkLM3ozu3M
CHAPTERS:
00:00 Introduction
01:22 Prerequisites
01:56 Create Relationships With Referential Integrity
04:35 Build an Inventory Search Query
08:13 Nested Subforms Overview
08:50 Create Continuous Forms for Inventory
11:01 Add the Item Subform to Subdivisions
13:49 Add Subdivisions to Areas
16:15 Build the Location Form
20:09 Extended Cut Preview: Cascading Combo Boxes
22:14 Recommended Courses
22:43 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Organizing Inventory 2: 599cd.com/OrganizingInventory2
PREREQUISITES:
Organizing Inventory, Part 1: 599cd.com/OrganizingInventory
Referential Integrity: 599cd.com/Referential
Parameter Query: 599cd.com/Parameter
Wildcard Search & Like: 599cd.com/Like
Continuous Forms: 599cd.com/Continuous
Subforms: 599cd.com/Subform
LINKS:
Nested Subforms: 599cd.com/NestedContinuous
RECOMMENDED COURSES:
Access Asset Seminar: 599cd.com/Asset
Access Barcode Seminar: 599cd.com/BarcodeSeminar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, inventory database relationships, referential integrity, nested subforms, inventory search query, parameter query wildcard search, continuous forms, cascade deletes, one-to-many relationships, cascading subforms, inventory data entry form
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will continue organizing inventory in Microsoft Access by creating table relationships and enforcing referential integrity. We will discuss cascade deletes, build an inventory search query with a wildcard parameter prompt, and create nested continuous subforms for locations, areas, subdivisions, and items so you can browse and enter inventory records within the hierarchy.
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will learn how to build a dedicated inventory entry form using reverse cascading combo boxes. I'll show you how to use Access's built-in cascading combo box features, use a small amount of VBA to reverse-cascade from an item's subdivision to its area and location, and use the older SQL-based method for manually filling the combo boxes. We will also keep the selected location and area values when entering multiple items in the same place.
MEMBERS-ONLY EXTENDED CUT VIDEO:
youtu.be/XTkLM3ozu3M
CHAPTERS:
00:00 Introduction
01:22 Prerequisites
01:56 Create Relationships With Referential Integrity
04:35 Build an Inventory Search Query
08:13 Nested Subforms Overview
08:50 Create Continuous Forms for Inventory
11:01 Add the Item Subform to Subdivisions
13:49 Add Subdivisions to Areas
16:15 Build the Location Form
20:09 Extended Cut Preview: Cascading Combo Boxes
22:14 Recommended Courses
22:43 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Organizing Inventory 2: 599cd.com/OrganizingInventory2
PREREQUISITES:
Organizing Inventory, Part 1: 599cd.com/OrganizingInventory
Referential Integrity: 599cd.com/Referential
Parameter Query: 599cd.com/Parameter
Wildcard Search & Like: 599cd.com/Like
Continuous Forms: 599cd.com/Continuous
Subforms: 599cd.com/Subform
LINKS:
Nested Subforms: 599cd.com/NestedContinuous
RECOMMENDED COURSES:
Access Asset Seminar: 599cd.com/Asset
Access Barcode Seminar: 599cd.com/BarcodeSeminar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, inventory database relationships, referential integrity, nested subforms, inventory search query, parameter query wildcard search, continuous forms, cascade deletes, one-to-many relationships, cascading subforms, inventory data entry form
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.










