Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

I no this isnt programming but have a newbie problem with relationships in access

Options
  • 06-11-2008 5:29pm
    #1
    twinytwo
    Registered Users Posts: 5,294 ✭✭✭


    k sorry if this is long winded....

    its a dvd store.. 5 tables

    STAFF- Staff ID(pk), Name, Age, Branch ID etc...

    BRANCH-Branch ID(pk), Address, Contact Number etc...

    DVD STOCK-CatalogueNum(pk),DVDNum, Supplier ID, Branch ID, Title etc..

    SUPPLIERS-Supplier ID(pk), Address, etc...

    MEMBERS-Member ID (pk) Name, Date Reg etc..

    RENTAL- DVDNUm(Pk), Member ID, Date out, Date in etc...

    I have a
    1:M relationship between staff and branch through Branch ID
    1:M relationship between branch and DVD Stock through Branch ID
    1:M relationship between DVD Stock and Supplier through Supplier ID
    M:M relationship between Branch and Members through Branch ID
    1:M relationship between Members and Rentals through Member ID


    I no that i need to remove the M;M relationship but not sure how..

    i just want to no would these relationships be correct or is there any better way of gooing about it


    so for a long and probally confussing post

    thanks to anyone who posts back


Comments

  • Options
    #2
    brianmc
    Registered Users Posts: 868 ✭✭✭brianmc


    twinytwo wrote: »
    k sorry if this is long winded....

    its a dvd store.. 5 tables

    STAFF- Staff ID(pk), Name, Age, Branch ID etc...

    BRANCH-Branch ID(pk), Address, Contact Number etc...

    DVD STOCK-CatalogueNum(pk),DVDNum, Supplier ID, Branch ID, Title etc..

    SUPPLIERS-Supplier ID(pk), Address, etc...

    MEMBERS-Member ID (pk) Name, Date Reg etc..

    RENTAL- DVDNUm(Pk), Member ID, Date out, Date in etc...

    I have a
    1:M relationship between staff and branch through Branch ID
    1:M relationship between branch and DVD Stock through Branch ID
    1:M relationship between DVD Stock and Supplier through Supplier ID
    M:M relationship between Branch and Members through Branch ID
    1:M relationship between Members and Rentals through Member ID


    I no that i need to remove the M;M relationship but not sure how..

    i just want to no would these relationships be correct or is there any better way of gooing about it


    so for a long and probally confussing post

    thanks to anyone who posts back

    A MEMBER_BRANCH table with MemberID, BranchID

    MEMBER 1:M MEMBER_BRANCH M:1 BRANCH


Advertisement