subforms

[thewabit]

Is this possible...?

I have a main form that has basic data about an event, dates, people, etc. There is a subform that gives details about the event. It is "linked" to the main form with a 1 to many relationship. Can I add another subform that contains some other grouping of information that I want to relate to the main form data? If so, what would the table/subtable presentation look like? Would it have 2 "+" signs next to each entry representing data from BOTH subforms?

Thanks!

[RuralGuy]

I would probably put two SubForms side by side on another form and then make that form a SubForm of your first form.

[thewabit]

Could you briefly describe how they would all "link" up?

[RuralGuy]

By the use of the LinkChild/MasterFields properties of the SubFormControls. If the MainForm is F1 and has SubForm F2 which has SubForms F3 & F4 on it then you can keep F4 in sync with F3 or F1 as you choose.

[thewabit]

I had to go another route for other reasons. 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.

[RuralGuy]

Those are called SubDataSheets and I do not use them. In fact doing so can impact the performance of the system. http://allenbrowne.com/bug-09.html

[thewabit]

Thanks Allan