Multiple Subform Problem

[Guest]

Hi

I have put together a form which currently has two subforms within it, and
each are linked to the primary key field in the main form as the parent. Is
this okay to do as when i try to add a 3rd subform which again uses the main
form primary key as the parent, access encounters an error and has to close.

Regards
Mike

 

[Guest]

This should not cause any trouble. Are the other subforms dependent on input
before the third subform can be filled with data? This might cause the
trouble.

 

[Guest]

Hi Maurice,

No the other two subforms do not need to be filled with data before the
third can. When a record is added to any of the three subforms, the Primary
ID is added to each of the foreign keys in the subforms - so presumabley this
okay?

Regards
Mike

==================

 

[Guest]

Mike,

This should be ok, so it looks like there is another problem bugging you.
Can you supply us with some additional info on the sources for the main and
three subforms?

 

[Guest]

Yeah sure. The main form contain information on submissions for tenders in
the construction field. Basically the main form contains the main details of
the submissions we put together. Subform 1 contains the team of external
associates involved in the submission, subform 2 contains the internal staff
team involved in the submission and subform 3 is for notes in relation to the
submission (also contains time and date that a note was recorded. All three
subforms are on the many side of the relationship. Was this what you were
looking for?

 

[Guest]

Hmm,

Don't see anything strange. Try making a new main form (leave the old one in
tact, the newe is just for testing) an link the first form to it. Try to add
a record. If this goes well, try it with the second form and so on. Then try
it with two forms and finally with all three.