Multi Value Fields - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multi Value Fields

Leo Rivera

5 years ago

Hi Rick, please give me light. I have a couple of fields in a tables that has multi values when I do a query the multi values works find until I put a different columns where the multivalued become gray. I will put in the table a column for product and service to fix my problem I know is not correct but I have not other choice so far.

	Leo Rivera OP @Reply 5 years ago
How can I send you a video or picture so you can understand better?

Richard Rost @Reply

5 years ago

Leo, I hate multi-value fields. I tell people in every one of my classes NOT to use them. I know you skipped over a lot of my Beginner courses, but I emphasize over and over again: DO NOT USE MULTIVALUE FIELDS. I refuse to support them or answer questions about them. Remove them and replace them with proper multi-table relationships.

As far as pictures go, see that little link on the top of your post to the right that says "upload images"? Use that. But if it's images about multi-value fields, no thank you. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View