A parent record with the rows that belong to it: phones on a contact, expenses on a vehicle, enrolments on a course. This is the Access subform. Membership terms sit with the specialist books below. Sample data only.
People and companies, phones, emails, addresses, and named lists. Combos store IDs. Not the parked Contacts slug. Sample data in this browser.
Family Support: one person form in three wrappers (Client, Carer, Sibling). Not Contact book. Sample data in this browser.
Training with attendance: courses, students, instructors, schedules, and enrolments. Not the Students year-group register. Sample data in this browser.
Club groups, dated sessions, members, roster, and roles. Not Complaints members. Sample data in this browser.
tblVehicles and tblExpenses. Expense type combo stores the ID. Select a vehicle to see its expenses (Access subform). Mark Sold. Sample data in this browser.
Properties, tenants, leases, and payments. Type combos store IDs. Menu: Properties, Tenants, or Leases. Sample data in this browser.
Estate-agency listings with brokers, sellers, and interested buyers. Not the landlord Real estate book. Sample data in this browser.
Properties, buildings, units, and guest bookings. Not the Real estate landlord book. Sample data in this browser.
tblMarketingProject plus deliverables. Budget vs the sum of child cost. Status and priority combos store IDs. Sample data in this browser.
tblEmployees and tblWorkHours. Work-code combo stores the ID. Select an employee to see their hours (Access subform). Menu: Employees or Hours. Sample data in this browser.
tblTransactions plus categories. Kind and category combos store IDs. Menu: Transactions or Categories. Sample data in this browser.
Publications, articles, and subscribers. Combos store IDs. Sample data in this browser.
Non-paying lot: associates, visitors, plates, in and out stays. Not fleet Vehicles. Sample data in this browser.
Parent groups and child rows linked by ParentId — the Access subform pattern.