I've studied Access for a couple years and can't seem to wrap my brain around the following: if a form and subform that has fields from multiple joined tables, how do you link the form with the subform so that the subform references the right record? I know the primary key of the parent table needs to line up with the foreign key in the child table, so I've been putting the foreign key on the subform and just making it invisible. But I've seen forms where the form and subform are linked seemingly without the foreign key field added. If anyone could tell me how to do that, I'd be really appreciative. Thank you!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!