Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

combining different drop down fields in one record into one field

Discussion in 'Information Technology' started by Nancy, Jul 28, 2006.

  1. Nancy

    Nancy
    Expand Collapse
    Guest

    I have a table with 5 fields, each of which are drop down. I need to combine
    the five fields in each record into one field for that record. I then need
    the entire record to be one drop down field. Is this possible? For example,
    my fields are "event, venue, date, time, parking". Can they be combined so
    that all those fields are in one field, so that my info in the record will be
    "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
    down field so that all events come up and can be chosen as one field?
     
  2. Loading...

    Similar Threads Forum Date
    Leisure Okay, so I am trying to sing in a different language... Business, Lifestyle & Leisure Jul 8, 2014
    How many different types of Sikhs are there? Sikh Sikhi Sikhism Jul 8, 2014
    Gurbani of a Different Flavour Intellectual Translations by SPNers Oct 29, 2013
    Leisure If you could go back in time, what would you do differently? Business, Lifestyle & Leisure Aug 25, 2013
    Opinion Facing Adversity - Different Reactions Breaking News Aug 18, 2013

  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Nancy,
    The data can be concatenated from the values you already entered.
    In an unbound text control use this Control Source...
    (use your own field names)
    = [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]

    Since you've already "captured event, venue, date, time, parking to your table, there's
    no need to also save that to another field after you've concatenated the values. Just
    "display" the concatenation.
    The concatenation can always be re-derived "on the fly" in any subsequent form, query,
    or report. Just the way we did it above.
    And... it can also be concatenated into the first column of your combo box for
    selection purposes.

    (although... you really should be using an EventID key field value for your combo
    selection, with the concatenation only there to assist the user in identifying the proper
    event)

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "Nancy" <Nancy@discussions.microsoft.com> wrote in message
    news:D716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
    >I have a table with 5 fields, each of which are drop down. I need to combine
    > the five fields in each record into one field for that record. I then need
    > the entire record to be one drop down field. Is this possible? For example,
    > my fields are "event, venue, date, time, parking". Can they be combined so
    > that all those fields are in one field, so that my info in the record will be
    > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
    > down field so that all events come up and can be chosen as one field?
     
  4. BruceM

    BruceM
    Expand Collapse
    Guest

    To expand a bit on what Al has written: You can combine the fields in the
    combo box row source. What follows assumes you have a primary key field.
    You can create a primary key that combines several fields, but a single
    field (autonumber, for instance, or any other unique identifier) will
    simplify things. One way to accomplish your intention is to use the combo
    box wizard. Be sure the magic wand icon is highlighted in the toolbox,
    click the combo box icon, and click the form to insert the combo box. When
    the wizard starts, select the option that begins "Find a record...", and
    click Next. Move the primary key field only to the right hand box, and
    click Next. Add the label name, and click Finish. Click the combo box to
    select it, then click View > Properties. Click the Data tab, then click the
    Row Source line. Click the three dots, which will open a query design grid.
    In the second (empty) column put something like:
    AllInfo: [NameField] & "/" & [DateField] & "/" etc. (use your actual
    field names).
    Use the third (and subsequent columns as needed) to add fields by which you
    wish to sort the records. Click the Sort row and make your choice.
    You don't need to store the combined field. In fact, you shouldn't. It
    will be calculated as needed.

    "Nancy" <Nancy@discussions.microsoft.com> wrote in message
    news:D716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
    >I have a table with 5 fields, each of which are drop down. I need to
    >combine
    > the five fields in each record into one field for that record. I then need
    > the entire record to be one drop down field. Is this possible? For
    > example,
    > my fields are "event, venue, date, time, parking". Can they be combined
    > so
    > that all those fields are in one field, so that my info in the record will
    > be
    > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
    > down field so that all events come up and can be chosen as one field?
     
  5. Nancy

    Nancy
    Expand Collapse
    Guest

    Re: combining different drop down fields in one record into one fi

    Oh my goodness - thank you! I'm a beginner though, and not smart enough to
    know what you are talking about. I'll try to figure it out though. I've
    come this far on my own so maybe I can make it all work. Thanks so much!

    "Al Camp" wrote:

    > Nancy,
    > The data can be concatenated from the values you already entered.
    > In an unbound text control use this Control Source...
    > (use your own field names)
    > = [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]
    >
    > Since you've already "captured event, venue, date, time, parking to your table, there's
    > no need to also save that to another field after you've concatenated the values. Just
    > "display" the concatenation.
    > The concatenation can always be re-derived "on the fly" in any subsequent form, query,
    > or report. Just the way we did it above.
    > And... it can also be concatenated into the first column of your combo box for
    > selection purposes.
    >
    > (although... you really should be using an EventID key field value for your combo
    > selection, with the concatenation only there to assist the user in identifying the proper
    > event)
    >
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "Nancy" <Nancy@discussions.microsoft.com> wrote in message
    > news:D716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
    > >I have a table with 5 fields, each of which are drop down. I need to combine
    > > the five fields in each record into one field for that record. I then need
    > > the entire record to be one drop down field. Is this possible? For example,
    > > my fields are "event, venue, date, time, parking". Can they be combined so
    > > that all those fields are in one field, so that my info in the record will be
    > > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
    > > down field so that all events come up and can be chosen as one field?

    >
    >
    >
     
  6. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Re: combining different drop down fields in one record into one fi

    Nancy,
    Check out what Bruce has posted.
    If you still have problems, or you have specific questions, post back on this thread.
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions


    "Nancy" <Nancy@discussions.microsoft.com> wrote in message
    news:594EF3A2-CDC5-4AC5-B443-2B69F388DF52@microsoft.com...
    > Oh my goodness - thank you! I'm a beginner though, and not smart enough to
    > know what you are talking about. I'll try to figure it out though. I've
    > come this far on my own so maybe I can make it all work. Thanks so much!
    >
    > "Al Camp" wrote:
    >
    >> Nancy,
    >> The data can be concatenated from the values you already entered.
    >> In an unbound text control use this Control Source...
    >> (use your own field names)
    >> = [Performer] & "/" & [Venue] & "/" & [EventDate] & " " & [EventTime] & "/" & [Parking]
    >>
    >> Since you've already "captured event, venue, date, time, parking to your table,
    >> there's
    >> no need to also save that to another field after you've concatenated the values. Just
    >> "display" the concatenation.
    >> The concatenation can always be re-derived "on the fly" in any subsequent form,
    >> query,
    >> or report. Just the way we did it above.
    >> And... it can also be concatenated into the first column of your combo box for
    >> selection purposes.
    >>
    >> (although... you really should be using an EventID key field value for your combo
    >> selection, with the concatenation only there to assist the user in identifying the
    >> proper
    >> event)
    >>
    >> --
    >> hth
    >> Al Camp
    >> Candia Computer Consulting - Candia NH
    >> http://home.comcast.net/~cccsolutions
    >>
    >> "Nancy" <Nancy@discussions.microsoft.com> wrote in message
    >> news:D716177A-2324-43CF-BD35-FF83483292D6@microsoft.com...
    >> >I have a table with 5 fields, each of which are drop down. I need to combine
    >> > the five fields in each record into one field for that record. I then need
    >> > the entire record to be one drop down field. Is this possible? For example,
    >> > my fields are "event, venue, date, time, parking". Can they be combined so
    >> > that all those fields are in one field, so that my info in the record will be
    >> > "Ray Charles/EA/Sun Mar 7/Comp"? That record then needs to become a drop
    >> > down field so that all events come up and can be chosen as one field?

    >>
    >>
    >>
     

Share This Page