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

Hi Charlotte

No, MVFs only allow one column.

Regards
Steve

-----Original Message----- 
From: Charlotte Foust
Sent: Thursday, November 01, 2012 3:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [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>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com