Tables
LabParents / LabChildren with logical FK ParentId (same seed as Phase 4 lab: 2 parents, 4 children).
Access → Web lab · Phase 4
Master–detail live demo
Online recreation of the Access laboratory sample
lab_phase4 — tables LabParents / LabChildren,
parent form frmLabParent with subform subChildren
(LinkMasterFields=Id, LinkChildFields=ParentId).
Select a parent — children filter like an Access subform (Id → ParentId).
| Id | Parent name | Children | Actions |
|---|
Select a parent to show linked LabChildren rows.
| Id | Child name | Qty | Actions |
|---|
Access mapping
Subform wiring
Access SourceObject=frmLabChild, LinkMasterFields=Id, LinkChildFields=ParentId → filtered child list in the browser.
Web pattern
Master list + filtered detail grid — not a nested Access control, but the same task fidelity for operators.