Urgent! Use multiple choice with access

[Dj87]

Hi, I do not know whether was already posted a request about this problem,
but my
problem is this.

I'd like to insert in a text field of a table of Ms Access some values from
a
list with the possibility of also choosing more than one.

From the combined square which I was using before passed to the square of
recapitulate activating the function of multiple selection with the problem
that if
all select one OK, select more than one in the field does not come
memorized nothing.

Did I forget any passage?

I must set up some other parameter. It is sufficient if
were selected more voices, these are stored in the associated field one
behind the other you separate from a comma or a point and comma.

Thanks, wait for reply.

Emanuele

 

[Jeff Boyce]

Putting more than one fact in one field is not consistent with good
relational database design. If there is more than one value possible, it
sounds like your data relationship is 1-to-many. To make the most of
Access' strengths, you'd need to modify your table structure to accommodate
the 1:M relationship.