Welcome to SPN

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

Sign Up Now!

Combo Boxes in Connection Tables for Many-to-Many Relationships

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

  1. Christian >

    Christian >
    Expand Collapse
    Guest

    I have a many to many scenario: Table A is one set of data, Table B is
    another, and Table C is my connection table for the data that is related
    many-to-many.

    Tables A and B are related to the appropriate fields in Table C. I am
    currently using combo bozes, so when entering data in Table C, a list appears
    from Table A or B. I selected No in "Limit to List."

    I have created a Form for entering Data in Table C--this is all I want the
    users to see.

    Question: How can I set it up so that new data that does not exist in A or
    B can be entered from the same field in Table C? I.e., suppose user is
    entering the Customer Field in Table C (Orders). This field pulls from a
    list of customers in Table A, but the Customer is new. I want the user to be
    able to simply type in the new customer's name and it is now added to Table A.
     
  2. Loading...

    Similar Threads Forum Date
    Black and Gold Boxes Inspirational Stories Jun 28, 2008
    Two Boxes Inspirational Stories Jul 26, 2007

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    You can find the solution by Checking http://www.mvps.org/access
    Hint: The NotInlist Event Procedure

    HTH

    Pieter


    <Christian > wrote in message
    news:BB508F42-6632-475E-9C64-496C796B8D1F@microsoft.com...
    >I have a many to many scenario: Table A is one set of data, Table B is
    > another, and Table C is my connection table for the data that is related
    > many-to-many.
    >
    > Tables A and B are related to the appropriate fields in Table C. I am
    > currently using combo bozes, so when entering data in Table C, a list
    > appears
    > from Table A or B. I selected No in "Limit to List."
    >
    > I have created a Form for entering Data in Table C--this is all I want the
    > users to see.
    >
    > Question: How can I set it up so that new data that does not exist in A
    > or
    > B can be entered from the same field in Table C? I.e., suppose user is
    > entering the Customer Field in Table C (Orders). This field pulls from a
    > list of customers in Table A, but the Customer is new. I want the user to
    > be
    > able to simply type in the new customer's name and it is now added to
    > Table A.
     
  4. Christian >

    Christian >
    Expand Collapse
    Guest

    Re: Combo Boxes in Connection Tables for Many-to-Many Relationship

    Okay, I found it. It's a visual Basic function...

    2 Questions:

    1. This seems like a pretty normal function, isn't there already a way
    within access?

    2. Besides adding to the drop down list, does this actually add to the
    other table?
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Re: Combo Boxes in Connection Tables for Many-to-Many Relationship

    No VB code at the site *only* VBA
    without the link I cant't say, but probobly yes ;-)

    The notInlist event *will' fire when an entry is not in the list

    HTH

    Pieter

    "Christian ><>" <Christian@discussions.microsoft.com> wrote in message
    news:38ABCB57-148A-40E6-9F03-2C664021EC35@microsoft.com...
    > Okay, I found it. It's a visual Basic function...
    >
    > 2 Questions:
    >
    > 1. This seems like a pretty normal function, isn't there already a way
    > within access?
    >
    > 2. Besides adding to the drop down list, does this actually add to the
    > other table?
     
  6. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Re: Combo Boxes in Connection Tables for Many-to-Many Relationship

    "Pieter Wijnen" <wijnen.nospam.please@online.no> wrote in message
    news:uIHP1X3eGHA.2188@TK2MSFTNGP05.phx.gbl...
    >
    > The notInlist event *will' fire when an entry is not in the list


    As long as the combo box's LimitToList property is set to True.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Re: Combo Boxes in Connection Tables for Many-to-Many Relationship

    I know,
    was to lazy

    ISC

    Pieter

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:ewlJDh3eGHA.5104@TK2MSFTNGP04.phx.gbl...
    > "Pieter Wijnen" <wijnen.nospam.please@online.no> wrote in message
    > news:uIHP1X3eGHA.2188@TK2MSFTNGP05.phx.gbl...
    >>
    >> The notInlist event *will' fire when an entry is not in the list

    >
    > As long as the combo box's LimitToList property is set to True.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
     

Share This Page