Inventory Management System Part 2 - Relationships, Searching for Items, and Nested Subforms @599CD
Inventory Management System Part 2 - Relationships, Searching for Items, and Nested Subforms  @599CD
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.
Inventory Management System Part 2 - Relationships, Searching for Items, and Nested SubformsThe Precision Error Behind A Patriot Missile FailureBig Access Forms Can Break On Other PCsWas Microsoft Access Really The Worst Database?Which Microsoft Access Report Layout Puts Each Customer on a Single Row? Video Quiz B1.12Do TempVars Conflict In Multi-User Access?Build Shared VBA Libraries, Reusable Forms & Reports, Connect Them. Microsoft Access Developer 63Why 0.1 Cannot Fit Exactly In BinaryAccess Did Not Launch With RushmoreAccess VBA Maintenance And Multi-Select FiltersWhy Highest ID Fails In Multiuser Access DatabasesMake Every Access Price End In 9
Computer Learning Zone |

Inventory Management System Part 2 - Relationships, Searching for Items, and Nested Subforms

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER