Nested Forms?

RobertJohn

Registered User.
Local time
Tomorrow, 05:44
Joined
Mar 24, 2008
Messages
14
Hi all

With Access 2007 is it possible to have a form which contains a subform, which itself also contains a subform? In other words, if I have a form (B) with a subform (C), can I insert that into another form (A), creating a set of "nested" forms?

Thanks

Robert
 
That was allready possible back in Access 2 (original version) so I dont see why 2007 should not be able to do that!
 
but you cant nest a subform in a continuous sub form

although you can get the correct behaviour by having two subforms in a single mainform
 
Thanks to you both.

My original post was, I now see, not clear. I know that the nesting notion is OK if the tables on which the forms are based are each pairwise linked by a one-to-many relationship. However in my case the relationships are each many-to-many. Does this make a difference?

Robert
 
Many-to-Many i.e. M:N tables/relationships??? :eek:

This is likely a design flaw! :rolleyes:

In a relational database there should only be 1:M M:1 relationsships! (with very very very very few exceptions)
 
Sorry, still not clear enough.

My tables are A, B and C, with junction tables (AB and BC) in between. I have A linked to AB in a one-to-many, and B linked to AB in a one-to-many, thereby creating a many-to-many relationship between A and B. Similarly with B and C.

My main information is in A, B and C hence the focus of my second post, ie 3 tables each pairwise linked with many-to-many relationships.

Does the nested forms concept work in these circumstances?

Thanks

Robert
 
Yes it works, except you need to nest the nest...

The junction tables (glad you know this term! :) ) need their own links/subforms to enable the 1:M N:1 and eventual M:N relationship.
 

Users who are viewing this thread

Back
Top Bottom