Multiple values in form field

[Cathy b.]

I'd like to create a data input form that will allow insertion of multiple
values a field. For instance, I have a one (eg., "Mom") to many ("Children")
table relationship and I would like to be able to create a record with all of
the Children on the same form. This form would populate the Children table
with a row for each child. I'd like to not have to do a separate input form
for each child. Is there a way I can do this?

 

[BruceM]

If you mean all of the children for a particular mother on the same form you
can create a form based on the Mom table and a continuous subform based on
the Children table. It is not about creating a record that puts all of the
Children records into a single field. Access 2007 does allow for such
multi-value fields, but there are many reasons not to use that approach. If
you have Access 2007 I can point you to a link that explains more. If not
it is not an option anyhow. You can create a comma-separated list within a
field, but if so there is no point to using Access. Excel or Word would be
a better choice if you don't intend to use the relational capabilities of
Access.

 

[Golfinray]

Typically, you use a form for the "one" side and a subform for the "many"
side. Then when you bring up one of the "moms" it displays the "children."