Urgent! Using multiple selectio with recapitulate square

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dj87 - 04 Jan 2005 10:41 GMT

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

Reply to this Message

Tim Ferguson - 04 Jan 2005 16:40 GMT

> 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.

...

> 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.

No: this is a bad idea. You really need to expand the design of the
database, so as to have another table for voices, so that each combination
of voice and (something) is stored in a new record in that table.

Somethings(*SomethingID, FieldTwo, FieldThree, etc)

VoicesUsed(*SomethingID+, *VoiceCode+, FieldC, FieldD)

Voices(*VoiceCode, F2, F3, F4, etc)

The * means the primary key and the + means a foreign key. In the
VoicesUsed table, the PK is made up of the combination of the SomethingID
and the VoiceCode, each of which reference the main tables. Fields C and D
may give extra information about how the particular Something uses that
particular Voice.

Don't try packing more than one fact into one database field: you will run
into awful problems trying to run queries after.

Hope that helps

Tim F

Reply to this Message