[AccessD] Regarding multi-value field, from a reader

Maybe a little remedial instruction on normalization for the reader?  I've
always avoided multi-valued fields like plague, but I wonder if you could
fake it by using a hidden column 0 in the listbox with a numeric sort order
and a visible column with the desired values?

Charlotte

On Wed, Oct 31, 2012 at 4:08 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> Received the following from a reader:
>
> "I set up a multivalued field in Access 2010 using a List Box and
> providing a Value List with values M,T,W,R,F. Everything works fine but for
> one problem. When I chose M, W, F from my list, th emultivalued filed reads
> F, M, W ... i.e., the entries are sorted left to right whereas I want them
> to show up as M, W, F. Is there a way to do this?"
>
> =====Other than learning the basics so I could write about them, I don't
> use them and have almost no experience. Anyone have a quick and easy
> answer? I'm going to do a little research, but if anybody knows, please
> share!
>
> Thanks!
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>