Store different groups of multivalue lists in a field of a table in Microsft Access 2 (1 Viewer)

wire_jp

Registered User.
Local time
Today, 04:49
Joined
Jun 23, 2014
Messages
64
Hi Everyone,

I am working on a MS Access 2013 database. I have a field called "Manual" which contain some values 1,2,3,7, Is it possible for a user to populate this 'Manual" field with different groups of multivalue lists at the same time e.g. the user can choose 1 and 7 or 1,2 or 1,3?

Thanks,

wire_jp
 

bob fitz

AWF VIP
Local time
Today, 11:49
Joined
May 23, 2011
Messages
4,717
IMHO multi-value fields are a bad idea. I would not use them. Normalize the data properly and create another table.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 06:49
Joined
Feb 28, 2001
Messages
26,996
To support bob fitz's opinion, remember that adding a multi-value field immediately adds "baggage" to the table that will NEVER go away. The problem with a multi-value list might be in defining it or loading it, but rather the next time you have to use it from some other object in the database, be it a form or VBA code or a relationship diagram.
 

wire_jp

Registered User.
Local time
Today, 04:49
Joined
Jun 23, 2014
Messages
64
Thank you for the feedback. I will avoid using the MVLs.
 

Users who are viewing this thread

Top Bottom