Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    30

    Unanswered: allowing multiple entries in a field

    Hi, I was wondering how one would set up a field in a table to allow multiple entries in it, maybe separated by commas or space...sorry this seems like it should be a simple question, but I am new to databases, if anyone can help me I would appreciate it.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Hmmm... and why do you need to do this?


    The exact method for inserting "multiple entries" is going to depend on exactly what method you are using to obtain each entry.

    The real question I would askis what table layout are you using that would require you to do this?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2003
    Posts
    268

    Cardinal Rule

    Thow shalt not store mutlivalue items in a field...

    This will only turn around and bite you in the arse.

    Create a new table with the PK from the first table and a second field for what you want to store. Then make the two fields a composite key.

    If you ever want to try and sort, filter, quantitize the information froma multi-value field it is way too much work.

    This is from experience..... trust me.

  4. #4
    Join Date
    Jun 2004
    Posts
    30
    haha thanks...I did think a way around it, but its good to know to not even go there

Posting Permissions

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