Welcome to SPN

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

Sign Up Now!

fields in combo box

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

Tags:
  1. Bird

    Bird
    Expand Collapse
    Guest

    I'm a novice access programmer. However I know my way in relational
    database design. My question is the following:

    If I want to pick a record from a table (with a multi attribute key) to
    use in another table where those attributes are part of the key of that
    table I want idealy use a combo box which shows the fields of the first
    table (iets key values) en then 1:1 copy those fields in the target
    table. The standard combo box allows me only to select 1 attribute.

    What do I mis here? How can I solve my problem?

    Thanks in advance
     
  2. Loading...

    Similar Threads Forum Date
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (New Kerala) Breaking News Apr 1, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (Calcutta News) Breaking News Apr 1, 2008
    Sikh News Punjab's killing fields (The Times of India) Breaking News Feb 24, 2008
    Sikh News MQM fields 218 candidates in Punjab (The Pakistan Link) Breaking News Feb 1, 2008

  3. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    It sounds like you need a ListBox instead. A ComboBox will only let you
    select one item, but in a ListBox (provided the Multi Select property is set
    to Extended) you can select multiple items.

    -Michael


    "Bird" wrote:

    > I'm a novice access programmer. However I know my way in relational
    > database design. My question is the following:
    >
    > If I want to pick a record from a table (with a multi attribute key) to
    > use in another table where those attributes are part of the key of that
    > table I want idealy use a combo box which shows the fields of the first
    > table (iets key values) en then 1:1 copy those fields in the target
    > table. The standard combo box allows me only to select 1 attribute.
    >
    > What do I mis here? How can I solve my problem?
    >
    > Thanks in advance
    >
     
  4. Bird

    Bird
    Expand Collapse
    Guest

    Michael H wrote:
    > Hi.
    >
    > It sounds like you need a ListBox instead. A ComboBox will only let you
    > select one item, but in a ListBox (provided the Multi Select property is set
    > to Extended) you can select multiple items.
    >
    > -Michael
    >
    >
    > "Bird" wrote:
    >
    >> I'm a novice access programmer. However I know my way in relational
    >> database design. My question is the following:
    >>
    >> If I want to pick a record from a table (with a multi attribute key) to
    >> use in another table where those attributes are part of the key of that
    >> table I want idealy use a combo box which shows the fields of the first
    >> table (iets key values) en then 1:1 copy those fields in the target
    >> table. The standard combo box allows me only to select 1 attribute.
    >>
    >> What do I mis here? How can I solve my problem?
    >>
    >> Thanks in advance
    >>

    Thanks Michael, I'm gonna experiment with your suggestion!
     

Share This Page