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

Another reason to avoid them!

Charlotte

On Wed, Oct 31, 2012 at 8:50 PM, Steve Schapel <
steve at datamanagementsolutions.biz> wrote:

> 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>
>> <http:**//databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>> >
>> Website: http://www.databaseadvisors.****com<http://www.**
>> databaseadvisors.com <http://www.databaseadvisors.com>>
>>
>>  --
> 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<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>