Table's field multiselection

[Niklas]

Pls. advice - I have a table with a field containing 3
values. Right now it is possible to select only one value
per record. I want to select several values per record.
Possible?

Lookup for that field is ...
Display Control: Combo Box
Row Source Type: Value List
Row Source: "Value1";"Value2";"Value3"

Thanks!

 

[Jeff Boyce]

Niklas

It sounds like you are saying the table's field is defined as a lookup data
type. If so, this data type causes considerable confusion.

It also sounds like your field can hold more than one value at a time ("a
field containing 3 values") -- relational database design frowns on this (if
that's what you are doing, or trying to do).

It sounds like you are working directly in the table -- consider using a
form for your data entry, as it will give you much more control over
when/how data is added/edited.

If you have a one-to-many relationship ("I want to select several values per
record"), you'll need to design a "many" (or child) table to hold that info.

If you provide more information about the data in your table and the
relationship, the 'group may be able to offer alternate approaches.

Good luck

Jeff Boyce
<Access MVP>

 

[Ayelet]

If I unedrstand your problem correctly, it's possible you
just need 3 fields of Yes/No data type,
for "Value1", "Value2" and "Value3", so that you could
choose any combination, none or all of them for each
record.

 

[Jeff Boyce]

Niklas

If your situation is that one person "can be [a] member of several clubs",
then consider creating a more normalized table structure ... perhaps
something like:

tblPerson
PersonID
...

tblClub
ClubID
...

trelMembership
MembershipID
PersonID
ClubID
?DateJoined
...

With this structure, it is a simple query of the trelMembership table to
find all the members of a given club (all the same ClubID), or all the clubs
for a given person (all same PersonID).

You will have many headaches and much extra work if you try to "stuff"
multiple club memberships into a single field.

Good luck

Jeff Boyce
<Access MVP>