Welcome to SPN

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

Sign Up Now!

One to Many relationship

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

  1. David Billigmeier

    David Billigmeier
    Expand Collapse
    Guest

    Hello - How can I set up a one-to-many relationship? For example I have the
    following 2 files and layouts:

    member_id product_id
    1 A
    2 B
    3 B
    4 A
    5 C

    product_id product_desc
    A software
    B hardware
    C accessories

    So the second table would be the "one" and the first table would be the
    "many". I've seen this in the relationship window, where there will be a "1"
    and an infinity symbol printed on either side of the line that connets the 2
    tables.

    Thanks,
    Dave




    --
    Regards,
    Dave
     
  2. Loading...

    Similar Threads Forum Date
    Reglion Many Lives, Many Masters - A Case For Reincarnation? Book Reviews & Editorials Jun 6, 2016
    How many times? Blogs Oct 16, 2015
    How many different types of Sikhs are there? Sikh Sikhi Sikhism Jul 8, 2014
    India The many British connections to massacres of Sikhs Breaking News Mar 29, 2014
    Learn Punjabi How Many At SPN Are Learning Punjabi? Language, Arts & Culture Nov 14, 2013

  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "David Billigmeier" <dtbill21@hotmail.com> wrote in message
    news:F040713F-9F2E-4637-AC62-97D1B3ED79E5@microsoft.com
    > Hello - How can I set up a one-to-many relationship? For example I
    > have the following 2 files and layouts:
    >
    > member_id product_id
    > 1 A
    > 2 B
    > 3 B
    > 4 A
    > 5 C
    >
    > product_id product_desc
    > A software
    > B hardware
    > C accessories
    >
    > So the second table would be the "one" and the first table would be
    > the "many". I've seen this in the relationship window, where there
    > will be a "1" and an infinity symbol printed on either side of the
    > line that connets the 2 tables.


    Let me know if this simple answer isn't what you're looking for.

    1. Make Sure that product_id is the primary key of the table of
    products.

    2. Open the Relationships window.

    3. Add both tables to the Relationships window, if they aren't already
    there.

    4. In the Relationships window, drag the product_id from the products
    table and drop it on the product_id in the other table.

    5. This will open the Edit Relationships dialog, to specify the
    properties of the relationship between these two tables/fields. It
    should show the relationship type as One-to-Many, in the direction you
    want it.

    6. To cause the relationship to be enforced, which you probably want to
    do, check the box "Enforce Referential Integrity". You may or may not
    want to check the subordinate boxes about cascading updates and deletes.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. David Billigmeier

    David Billigmeier
    Expand Collapse
    Guest

    Hi Dirk -
    Thanks for the response. I do that, however it always says "Intermediate"
    for relationship type, and I can't seem to manually change it over to
    "One-to-Many".


    --
    Regards,
    Dave


    "Dirk Goldgar" wrote:

    > "David Billigmeier" <dtbill21@hotmail.com> wrote in message
    > news:F040713F-9F2E-4637-AC62-97D1B3ED79E5@microsoft.com
    > > Hello - How can I set up a one-to-many relationship? For example I
    > > have the following 2 files and layouts:
    > >
    > > member_id product_id
    > > 1 A
    > > 2 B
    > > 3 B
    > > 4 A
    > > 5 C
    > >
    > > product_id product_desc
    > > A software
    > > B hardware
    > > C accessories
    > >
    > > So the second table would be the "one" and the first table would be
    > > the "many". I've seen this in the relationship window, where there
    > > will be a "1" and an infinity symbol printed on either side of the
    > > line that connets the 2 tables.

    >
    > Let me know if this simple answer isn't what you're looking for.
    >
    > 1. Make Sure that product_id is the primary key of the table of
    > products.
    >
    > 2. Open the Relationships window.
    >
    > 3. Add both tables to the Relationships window, if they aren't already
    > there.
    >
    > 4. In the Relationships window, drag the product_id from the products
    > table and drop it on the product_id in the other table.
    >
    > 5. This will open the Edit Relationships dialog, to specify the
    > properties of the relationship between these two tables/fields. It
    > should show the relationship type as One-to-Many, in the direction you
    > want it.
    >
    > 6. To cause the relationship to be enforced, which you probably want to
    > do, check the box "Enforce Referential Integrity". You may or may not
    > want to check the subordinate boxes about cascading updates and deletes.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
    >
     
  5. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "David Billigmeier" <dtbill21@hotmail.com> wrote in message
    news:2BAC13BC-CB4B-41C8-B874-E662EEA0FBEB@microsoft.com
    > Hi Dirk -
    > Thanks for the response. I do that, however it always says
    > "Intermediate" for relationship type, and I can't seem to manually
    > change it over to "One-to-Many".


    Maybe you have a unique index set on the foreign key "product_id" in the
    other table. Make sure the field is either un-indexed, or has its
    Indexed property set to "Yes (Duplicates OK)".

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page