Thanks, Rick. You clearly demonstrate subform creation using one-to-many relationships and how you can relate and show all the detail from each each table using continuous forms. I'd like to do the exact same thing with many-to-many relationships: use continuous forms and show all the detail, not only the "product" and "vendor" names (so to speak). Would that require using dlookup from an ID field in the the junction table subform to autopopulate a subsubform with the detail? And, in the video, why place the subforms in the footer instead of in the body of the form? Thank you!
You could join together any related info you want to display in a query, but keep in mind that info would only be for display only. You won't be able to edit it (usually).
You can ONLY put a subform in the form header or footer sections. Access won't let you put it in the detail section. Think about it, you'd have a copy of the subform for EACH detail record. It wouldn't look right.
I know it will be a strange one, but, Can the the footer be on the right not in the bottom ? I know you laughing, but what I am trying to accomplish is to nest the subform horizontally instead of vertically, you know; like tree folder system