Microsoft Access Inventory Relationships, Search Queries, and Nested Subforms

In part two of this Microsoft Access inventory database series, learn how to connect locations, areas, subdivisions, and items with proper one-to-many relationships and referential integrity. The focus is on keeping inventory data organized so items cannot be assigned to locations that do not exist, while avoiding the risks of cascade deletes.