Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Multi Field value field in Microsoft Access

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 19-11-2009
Member
 
Join Date: Nov 2009
Posts: 779
Multi Field value field in Microsoft Access
  

Hi,
I need some examples about how to use Multi-Field values of it. I also need a small description of this. I have some tables where I want to apply this option. As never done this before so I have some doubts. Like how values accepts a multi-value field. And now can I display labels instead of values in a multi-value field. In the same way is it possible to use the Multi-Value fields with a large volume of data. Thanks in advance.

Reply With Quote
  #2  
Old 19-11-2009
Member
 
Join Date: Jan 2008
Posts: 3,755
Re: Multi Field value field in Microsoft Access

The Multi-Value fields can store multiple values in one field. They replace the tables and relationships used in many to many. Lest take a sample here. Below there are products with quantity. Product (Tea, Coffee, Cold drink). Quantity (2,4,6). So when you create table and then use this function the result would be like this. (Tea, Coffee, Cold drink, quantity)
Reply With Quote
  #3  
Old 19-11-2009
Member
 
Join Date: May 2008
Posts: 3,308
Re: Multi Field value field in Microsoft Access

Fields in multi-valued fields are represented as sub-recordset, the number of values does not seem limited. Anyway, I managed to insert more than 100,000 values without errors. Note, however, it is evident that many values will quickly drop performance. In an application, a multi-value field displays only the value of the bound column of the list box.
Reply With Quote
  #4  
Old 19-11-2009
Member
 
Join Date: May 2008
Posts: 4,559
Re: Multi Field value field in Microsoft Access

The volume of data reaches the 100,000 lines, the performance is poor. The processing time is about 10 times longer than a 1-N relationship. However, not limited to such a test so few records. Also, on a much more extensive (200 classes for 10,000 students and an average of 10 students per class), it appears that the use of fields Multi-Value becomes truly detrimental. For proof, one call of the R03 application is run 0.8 seconds, while the appeal of R02 requires more than 10 seconds.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Multi Field value field in Microsoft Access"
Thread Thread Starter Forum Replies Last Post
count commas in a text field in Access SeaGuy Windows Software 4 07-09-2011 08:12 PM
Use Of Auto Increment field In Access database Pony Software Development 5 03-02-2011 09:24 PM
Field properties in Ms Access 2007 Bansi_WADIA Windows Software 5 08-01-2010 04:10 AM
How to combine two field in access X-Man Windows Software 3 08-06-2009 11:16 PM
To access a text field from another form Sanket07 Software Development 6 06-02-2009 05:42 PM


All times are GMT +5.5. The time now is 11:12 PM.