Microsoft Access Multivalued Fields: What They Are, How to Use Them, and When You Should Avoid Them

In this Microsoft Access tutorial, I will teach you about multivalued fields: what they are, how to use them, and when you should avoid them.

Craig from Brattleboro, New Hampshire (a Platinum Member) asks: I inherited a database from my predecessor. In it, she used multivalued fields to track the sales reps assigned to a customer, as there can be several. I've watched many of your videos where you say not to use them, but in all honesty, they seem to work just fine. What's the deal?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to programmatically access the elements of a multivalued field using a recordset loop. I will also show you how to add selections.

MEMBERS VIDEO:
   • Microsoft Access Multivalued Fields E...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/MVF

LINKS:
Evil Access List: https://599cd.com/Evil
Many to Many: https://599cd.com/ManyToMany
Custom List Box: https://599cd.com/CustomListBox
Relational Combo: https://599cd.com/Relational

SUGGESTED COURSES:
Many to Many: https://599cd.com/ACX7
Multi-Select List Box: https://599cd.com/ACD15
Referential Integrity: https://599cd.com/ACX2

MULTIVALUED FIELD REFERENCES:
http://access.mvps.org/access/lookupf...
https://www.isladogs.co.uk/multivalue...
https://tinyurl.com/yyxvx7h6
http://www.accessmvp.com/thedbguy/dem...

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, multivalued field, mvf, lookup field, allow multiple values, lookup wizard, many to many relationship, junction table, got geddy

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.