Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: multiple records appended into a single record on another table

    Is it possible to use a query/code to append multiple records from one table into a single record on another table.

    I am using 'option buttons' on a form to let people select up to 3 items that they want included as part of a whole.
    What I want and don't know how (or if it is possible) is to then add these selections to another table, as a several entry seperated by commas, so that they can be printed out as one entire selection choice rather than 3 seperate choices..

    any help would be appreciated.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Depending on the practical application of your question, you may be better off setting up a couple tables to hold your values. I like this method for temporarily storing preferences or selections.

    First create a table for "sessions" or whatever you want to call your group of preferences. Then create a table for "session_details" (again, the name is arbitrary). when you're user is about to make some selections, create an entry in sessions to obtain a key. Then apped each selection into you're session_details table along with the key generated by "sessions". You can then play with the data in a much greater variety of ways.

    Alternately, if there is only one user at a time, a simple yes/no bit hooked up to whatever table you're dealing with would work just fine.
    oh yeah... documentation... I have heard of that.

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

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    Thanks... I hadn't thought of the different tables approach.. That's why it is sometimes better to ask someone, to give an obvious and sometimes simple solution..

Posting Permissions

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