subforms

[thewabit via AccessMonster.com]

So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with
"ObID".



Now when I go to the Table for F1, the subtable "+" sign no longer works to
pull down the subtable.



I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

 

[John W. Vinson]

So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with
"ObID".



Now when I go to the Table for F1, the subtable "+" sign no longer works to
pull down the subtable.



I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

Um?

Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow
you to do this easily), or a *TABLE* with *SUBTABLES*?

If the latter, be aware that table datasheets are not well designed for data
entry or editing. They're very limited. For instance, I don't think you can
have two active subtables; whereas with a Form you could very easily (if at a
performance hit) have ten or more subforms.

 

[thewabit via AccessMonster.com]

Yes...I have since learned that what I should have said was "subdatasheets".
I guess I was looking for 2 subdatasheets to drop down since I had two
different tables with a relationship with my main table. It looks like it can
only do one subdatasheet and they are not even recommended. I got the
subforms to work properly...

Thanks John.

So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with

[quoted text clipped - 5 lines]

I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

Um?

Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow
you to do this easily), or a *TABLE* with *SUBTABLES*?

If the latter, be aware that table datasheets are not well designed for data
entry or editing. They're very limited. For instance, I don't think you can
have two active subtables; whereas with a Form you could very easily (if at a
performance hit) have ten or more subforms.