Multi Valued Fields

[thegrimmerdiscovery]

Multivalued fields.
They seemed great to me in selecting multiple criteria for agiven single field – which is a common requirement of the very simple databases Ihave to create. But then I started to find that they were a nightmare to unpickwhen setting up queries and so on.

As far as I can gather, I’m pretty much the last person onearth to tread this path. BUT…try as I might, reading around variousconversations on just this topic, I simply cant replicate what mvfs do in termsof being able to , well, select multiple values for a single field on a form whichthen transposes those same multiple selections back to the datasheet. Could someone point me in the direction ofsome brain-dead simple instructions on how to do this.

Thanks in advance

[ranman256]

I never found a use for them. A user can pick multiple items from a list box,(Normal table)
and store them in a sub table. Easy.

for muliValue field,it's a recordset in a recordset.
avoid it.

[davegri]

See if this can help get you out of the woods:

https://www.accessforums.net/showthread.php?t=77252

https://www.accessforums.net/showthread.php?t=79814

[Micron]

I think you're asking how to replicate the feature without actually having to use it, not how to convert it to a normalized structure. In many years of Access I have only had a need for this one time, and that was not long ago. Try as I might, I could find no other solution but I chose csv values and not the usual form of this. So it was a type of mvf in my opinion, but not one created by Access. I would not characterize this as 'brain dead simple' as you put it. The input values were added to an array and the csv output string became the field value. In order to display this on a form required populating the array then splitting off the values into the proper controls. The reason for the approach was that the input form was grid-like (calendar of sorts) with dates as records and trades as fields.

[thegrimmerdiscovery]

thanks for your help people - appreciated