Results 1 to 4 of 4

Thread: Multi Field value field in Microsoft Access

  1. #1
    Join Date
    Nov 2009
    Posts
    798

    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.

  2. #2
    Join Date
    Jan 2008
    Posts
    3,758

    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)

  3. #3
    Join Date
    May 2008
    Posts
    3,319

    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.

  4. #4
    Join Date
    May 2008
    Posts
    4,574

    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.

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •