Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    15

    Unanswered: Access 2007-10 table lookup, multiple entry Help

    Hello everyone

    I am kinda new to Access (well I used it back in 2002 my last time)

    and I am trying to create a simple database

    it consist of three tables

    one of the tables is used as data lookup to fill the field in another table

    my problem is that this should be a multiple value field which is easy, but the problem is I need to create a code,form or anything that gives me the multiple values separated by a comma in a message box for example

    Thanks very much
    Attached Thumbnails Attached Thumbnails query lookup.JPG  

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Stay as far away as you can from tables with multiple values fields. This is one of the worst idea the Access team ever had (and probably ever will have).

    They seem to be easy but actually are a nightmare to handle programmatically. You cannot even issue a simple INSERT or UPDATE SQL statement to them, but the main point is that they totally contradict the normal forms that constitute the foundations of a relational database. From the first normal form:
    A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only
    See (among many others):
    A Simple Guide to Five Normal Forms in Relational Database Theory
    The 5 Normal forms in Database Design
    Database Normalization Basics
    http://www.dbis.informatik.hu-berlin.../Maier/C06.pdf
    First Normal Form (1NF) - Normalising Your Database | Database Solutions for Microsoft Access | databasedev.co.uk

    If this can help you, you can retrieve a "csv-like" list of values from a multi-value column using a DLookUp function.
    Have a nice day!

  3. #3
    Join Date
    Jan 2012
    Posts
    15

    Thanks

    Thanks a lot for your quick reply, I am gonna check all the links you provided and let you know how I go
    Thanks again

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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