cannot include two M:M relationships within same form

[ugly]

My db has three tables: drawing, unit, and component. A unit is based on a drawing and a unit has components. Drawing to unit is M:M as is unit to component. I inserted two junction tables and that appears to work fine. I want to show data from all 3 tables on the same form by using the form wizard and this will take the form of nested sub forms. So drawing then a nested units then components. The form wizard will not do this, If I try just two say drawing and unit that’s fine. But it seems that I cannot include two many to many relationships on the same form?

 

[MajP]

You can do this, but not using the wizard. You would need to make two synchronized continuous subforms. This can be done several ways see faq702-5860 for one way to do this. So one design would be:
Main form based on the Drawings table.
Continuous Subform one based on a query of junction table one and the unit table linked by Drawing ID
Continuous subform two based on junction table two and the components table synchronized to the first subform by the unit id.

Also two synchronized continuous subforms will be much more intuitive to the user then nested subforms. You will have to either shut the wizard off by unclicking the magic wand icon, or drop the subforms on to the main form and create a dummy master child relationship. Then delete the relationship as needed in design view.