×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Multivalued fields in Access 2010
4

Multivalued fields in Access 2010

Multivalued fields in Access 2010

(OP)
Using Access 2010. I am not using Multivalued fields (or any Lookup fields) and I don't want to use them. I want to see the normalization. But if I'm a dinosaur I want to know it... Are people who design in Access professionally using them? MVPs? Will there come a day when only old people avoid them? If your customer uses SharePoint, are you more likely to use them?

--Lilliabeth

RE: Multivalued fields in Access 2010

Yeah, they make the hair stand up on the back of my neck. But they are needed for sharepoint compatibility. But, like you said, the good news is they are normal. The bad news the normalization happens behind the scenes.  I do not think anyone uses them.  I have not scene a single thread in Tek-tips since 2007 came out, either from novice or advanced users.  The only threads have been me telling users if they wanted that functionality it does exist in 2007.

RE: Multivalued fields in Access 2010

using Multivalued fields
IMHO, only for SharePoint compatibility ...

RE: Multivalued fields in Access 2010

I was sitting in the room in Redmond when the Access MVPs were first introduced to multivalued fields. To put it mildly, the new functionality/feature was not embraced.

I have never used them and agree with points made by MajP and PH.

Duane
Hook'D on Access
MS Access MVP

RE: Multivalued fields in Access 2010

Multivalued fields were the norm in Pick / Prime Information back in the day and are still used in Mumps and other related databases.

Even so, I do not foresee using them myself in Access anytime soon.

Keep in mind that you will not necessarily be losing normalization if you use multivalues. Your tables could still be conceptually normalized, but not physically. I'm splitting hairs here - it's all in how you perceive it.

A quick example: all order items (multivalues) could be included in a single read of an order record (row). There are certainly good ways and bad ways to use them, just as there there are good and bad designs now.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

RE: Multivalued fields in Access 2010

Now that I've done some reading on Access multivalues, I'm sure I'd never use them - they're not quite the same as my experience in other databases. blush

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

RE: Multivalued fields in Access 2010

(OP)
Thanks, all. I feel better.

--Lilliabeth

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close