Access Main Form and Subform for data from tables Related in a 1 to Many Relationship ~ DataPig
How to design forms to present data from tables in a 1 to many relationship. It starts with creating a separate Main form (Employee) and a second form (the subform Orders), then adjusts the design of the mainform to include a subform control. The Orders form populates the subform control and EmployeeID is the link field between the form and subform. The subform design is adjusted to remove unneeded options and fields. The datasheet view of the subform is demonstrated.
NOTE: you can also add a subform to a mainform by dragging it from the Navigation Pane. To set up the linking, set LinkMasterFields and LinkChildFields for the subform control on the Property Sheet. Instead of deleting the linking field from the subform though, it's best to leave it there and set Visible to False -- perhaps move it to form header or footer.
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.