Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 12-14-2011, 04:30 AM   #1
zyousafi
Newly Registered User
 
Join Date: Jun 2010
Location: Lahore, Pakistan
Posts: 39
Thanks: 1
Thanked 0 Times in 0 Posts
zyousafi is on a distinguished road
Multivalued Fields

I have been trying for the past several hours to get this work but for some reason I am not getting the same options that are shown on Microsoft Office's website (i.e. the tutorial) on multivalued fields. Supposedly, as per Microsoft, there is an option when you select "Lookup Column" in Datasheet View that asks you whether or not you want to store multiple values in that particular field; however I am using Microsoft Access 2007 and I am getting no such option. Are multivalued fields really this complicated/tricky? I am building a software for my HCM (i.e. that is HR to some of you) Department and when an employee can speak multiple languages the same needs to be marked and recorded in the system. How can I go about doing this?

zyousafi is offline   Reply With Quote
Old 12-14-2011, 04:19 PM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Multivalued Fields

I prefer to avoid multi-valued fields simply because they make it more difficult to work around than just having your own table which stores the values. Yes, it makes for a nice interface, but when you start needing to do things with the data it can become a pain.

When you use a multi-valued field you need to select that as the datatype. It then stores the data as a variant. Also, you really should avoid using the lookups directly at table level (outside of the multi-valued fields).
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 12-14-2011, 04:43 PM   #3
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,651
Thanks: 98
Thanked 1,499 Times in 1,414 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: Multivalued Fields

You won't get the option if you are are using an mdb database.

I also agree wholeheartedly with Bob and most professional developers. Use a related table.

Not only are multivalue fields more difficult to query and particlarly hard to manage in code they are not available in any other database format. So when you eventually need to upsize to a server backend you would have to redesign tables forms and reports.

Moreover most HR databases are held on a server backend because Access simply does not support the sort of security expected for the privacy considerations of HR.

Galaxiom is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can multivalued fields feature in Access 2007 be disabled? Steve R. Queries 2 07-30-2011 06:44 AM
Use a ComboBox to Filter a MultiValued Field thensrud Forms 0 02-14-2011 01:07 PM
multivalued field and insert into / append honza7632 Queries 5 01-30-2011 04:28 AM
Multivalued lookup using Access 2007 lmcc007 Forms 4 04-11-2010 03:23 AM
Use multivalued field results in query Debsmeth Queries 2 07-17-2008 10:37 PM




All times are GMT -8. The time now is 03:10 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World