Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Unanswered: relationship problems

    Hi im new to this forum but im hoping you guys can help.

    I am tryign to create a database which stores Businesses details within it.

    Along with them details the staff within a particular business.

    I have 4 tables.

    businesses (Stores business name,address, telephone, type of business etc)

    businessCategories (Stores different types of businesses eg. Garage, Nursing home etc)

    businessesStaff (Stores name, address and other personal details on staff members within the businesses)

    and finally ... businessRegister (Stores the usernames, passwords for logining on to the website and being abel to edit the businesses table and there account).

    Im just a little confused on how to go about the relationships, I have made one already "one-many" relationship between "biz_category" in the businesses table to the "cat_id" field in the businessCategories table.

    Is this correct? Any suggestions on my other realtionships?

    I have included a screen shot and a copy of my database file to date.

    Any help would be great.

    Thanks,

    yetiboy
    Attached Thumbnails Attached Thumbnails dbScreenshot.JPG  
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    why is biz_id the primary key for three different tables? what class is this for?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2005
    Posts
    2

    biz_id

    Hi Teddy,

    Thanks for your swift reply. I was under the impression giving to me by a friend who has done some databases that I needed the biz_id in each table I wanted to link to businesses.

    So that I could find which staff work in which businesses and what was that businesses username/password and other register details.

    Or am i totally off track?

    Thanks,

    yetiboy

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Check this out. It's a good primer on relational design, I highly recommend making sure you understand its concepts before proceeding, you will save yourself many headaches
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •