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!
March 17, 2009 6:46 PM
March 19, 2009 7:06 PM