Welcome to SPN

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

Sign Up Now!

Question on Access 2000 Design Many-to-Many Relationship ?

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

  1. SergioArena

    SergioArena
    Expand Collapse
    Guest

    Hello,

    The first table on my project an I'm already stuck.
    I need to build a table in access 2000 that contains some product information.
    This table contains several fields which were then separated into 6 tables.
    * TblItem (ID; ManufCode; DescriptionEN; Supplier; Cost; Imagelink)
    * TblSupplierCode (ID; SupplierCode)
    * TblSize (ID; Size)
    * TblStorage (ID; Storage)
    * TblShipping (ID; Shipping)
    * TblUNNumber

    In our industry there is only one manufacture for each product. This
    manufacture issues one ManufacturePartNumber for each item.
    However, I also need to relate this unique ManufacturePartNumber to several
    different Reseller Part Numbers.
    What would be the best approach for the tables ? I tried many-to-many
    relationship in access but I might have something wrong. Also tried lookup
    value as a table field in TblItem but can't seem to make it work.
    I know this is a basic question but any help would be greatly appreciated.

    sergioarena@hotmail.com
     
  2. Loading...

    Similar Threads Forum Date
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016
    Entering into Sikhism: Questions on Reht Maryada. Blogs Oct 22, 2015
    A question about kes/hair? Blogs Oct 21, 2015

  3. Amy Blankenship

    Amy Blankenship
    Expand Collapse
    Guest

    "SergioArena" <SergioArena@discussions.microsoft.com> wrote in message
    news:519F12A5-4A2D-4621-88AC-37010D1A962A@microsoft.com...
    > Hello,
    >
    > The first table on my project an I'm already stuck.
    > I need to build a table in access 2000 that contains some product
    > information.
    > This table contains several fields which were then separated into 6
    > tables.
    > * TblItem (ID; ManufCode; DescriptionEN; Supplier; Cost; Imagelink)
    > * TblSupplierCode (ID; SupplierCode)
    > * TblSize (ID; Size)

    Where is this being used?

    > * TblStorage (ID; Storage)

    What is this for? It doesn't appear in any other table.

    > * TblShipping (ID; Shipping)

    Same question.

    > * TblUNNumber

    Huh?

    So really I can help you with only the first 2 tables, since the other
    tables don't seem to have a use.

    >
    > In our industry there is only one manufacture for each product. This
    > manufacture issues one ManufacturePartNumber for each item.
    > However, I also need to relate this unique ManufacturePartNumber to
    > several
    > different Reseller Part Numbers.


    That means you need a Reseller table...

    ResellerID
    ResellerName
    ResllerStreet
    etc.

    And a ResellerParts

    PartID
    ResellerID
    ResellerPartNum.

    > What would be the best approach for the tables ? I tried many-to-many
    > relationship in access but I might have something wrong. Also tried lookup
    > value as a table field in TblItem but can't seem to make it work.
    > I know this is a basic question but any help would be greatly appreciated.


    Not sure what you're doing with this table, so that's as far as I can get
    you.

    HTH;

    Amy
     

Share This Page