Multiple Choice of the Multiple Choice

I'm getting confused. I have the following:

1. Main form containing "issues" (single form view)
2. Subform containing multiple "positions" to each issue (datasheet view)
3. Within the "positions" subform, two fields ("assigned people" and "list
of systems affected") needing multiple picks from a list also.
4. Each of the two fields have their own subform within the "position"
subform

Problem: When I originally had one field with multiple picks, a "plus"
showed in the corner of the datasheet view of the "position" subform, and I
would click on the plus to see the list of people assigned to the position.
Now I have another list "systems affected") and I created the same subform,
same table, etc. However, I cannot see the new subform. When I go to the
"positions" table, it lets me pick only one subdatasheet.

How do I handle this for the user to see both lists in the forms?

Debra Ann

On Mon, 6 Mar 2006 08:05:29 -0800, Debra Ann
wrote:

How do I handle this for the user to see both lists in the forms?

By using Subforms, rather than the very limited and
performance-damaging Subdatasheet feature.

You may need to use a single-view subform with two sub-subforms
(rather than a datasheet subform); if you really want to see multiple
records in the Positions subform, and at the same time see the
selected record's related records in the other two tables, you can use
"correlated subforms". Post back for details if you're interested,
it's not too hard but involves a bit of typing for instructions.

John W. Vinson[MVP]

John,

Thanks for the info. Yes I would love the directions on using correlated
forms. I never heard of it and the users are pretty serious about seeing
multiple poisitons on the subform all at one time.

Thanks and I appreciate the instructions in advance.

--
Debra Ann


"John Vinson" wrote:

On Mon, 6 Mar 2006 08:05:29 -0800, Debra Ann
wrote:

How do I handle this for the user to see both lists in the forms?

By using Subforms, rather than the very limited and
performance-damaging Subdatasheet feature.

You may need to use a single-view subform with two sub-subforms
(rather than a datasheet subform); if you really want to see multiple
records in the Positions subform, and at the same time see the
selected record's related records in the other two tables, you can use
"correlated subforms". Post back for details if you're interested,
it's not too hard but involves a bit of typing for instructions.

John W. Vinson[MVP]