D
Darrell
An issue I seem to face frequently is the "problem" of displaying the
"many" side of relationships in ways which suit my needs.
Currently, I have a need (if possible) to do something like this:
Display:
Record 1, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform1 record2 Subform3 record2
Subform3 record3
Record 2, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform1 record2 Subform2 record2 Subform3 record2
Subform1 record3 Subform3 record3
Subform1 record4
Record 3, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform2 record2 Subform3 record2
Subform2 record3 Subform3 record3
Subform2 record4
Subform2 record5
Etc...
This would be relatively easy to do in a report, but in a form it's a
different story. You cannot have subforms combined with a parent form
displayed in "Continuous Forms" mode, there is no "Hide Duplicates"
property for a control and, of course, there is no "On Format" event for
a form detail section.
Though I know that forms were designed for user interaction with the
data, it's a little frustrating. In this case, the user needs to
interact with the form to the extent that they will select one of the
"parent" records for yet further information, but want information from
subforms 1 through 3 in order to assist with their selection of the
parent record.
Is there any way to do this that I'm overlooking?
Thanks for all help ahead of time.
Darrell
"many" side of relationships in ways which suit my needs.
Currently, I have a need (if possible) to do something like this:
Display:
Record 1, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform1 record2 Subform3 record2
Subform3 record3
Record 2, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform1 record2 Subform2 record2 Subform3 record2
Subform1 record3 Subform3 record3
Subform1 record4
Record 3, field 1 field 2 field 3
Subform1 record1 Subform2 record1 Subform3 record1
Subform2 record2 Subform3 record2
Subform2 record3 Subform3 record3
Subform2 record4
Subform2 record5
Etc...
This would be relatively easy to do in a report, but in a form it's a
different story. You cannot have subforms combined with a parent form
displayed in "Continuous Forms" mode, there is no "Hide Duplicates"
property for a control and, of course, there is no "On Format" event for
a form detail section.
Though I know that forms were designed for user interaction with the
data, it's a little frustrating. In this case, the user needs to
interact with the form to the extent that they will select one of the
"parent" records for yet further information, but want information from
subforms 1 through 3 in order to assist with their selection of the
parent record.
Is there any way to do this that I'm overlooking?
Thanks for all help ahead of time.
Darrell