Followed the video for nesting one to many subforms, however I have 2 many to many tables (I believe) that I cannot for the life me get to work. I can get the bottom half to work but then when I add them in the subforms half the subforms don't change when I change the top record. 3 lookup tables that match two junction tables (2 table to one junction and 2 tables to the other junction. Looking for live assistance. thanks Dave
Kevin Robertson 16 months ago
Check the Link Master & Child fields and ensure there is a field in the relevant tables that they can be linked on.