Results 1 to 2 of 2
  1. #1
    trexsteve is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    1

    relationship diagrams help

    Hi i am new to ms access databases, really struggling with my tables relationships




    my database has more than one many-to-many relationships, for example one instructor can have many classes, one class can have different instructors, one client could have different instuctors, one instructor could have many clients and all at different times, on different days


    eg: 18/06/2013 Time: 8:00, Instructor: Steven, Class :Pilates, Clients: Bob,
    Andrew,
    Jess,
    Alex


    Time: 9:30, Instructor: Thomas, Class :Yoga, Clients: Alexis,
    Kerry,
    Alex,
    Bob

    22/06/2013 Time: 10:00, Instructor: Greg, Class :Reformer, Clients: Bob,
    Harry,
    Jess,
    Alex


    Time: 16:30, Instructor: Fred, Class :Yoga, Clients: Alexis,
    Kerry,
    Alex,
    Alexandra
    (Each day can have many of these at any times)


    really struggling on this one, its probably really though any help on relationship diagram would be greatly appreciated

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See this tutorial. I you follow the approach I'm sure it will help.
    http://www.rogersaccesslibrary.com/T...lationship.zip


    Her is a youtube video dealing with many to many relationships
    https://www.youtube.com/watch?v=7XstSSyG8fw

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating Block Diagrams from Access Database
    By SasQuach in forum Programming
    Replies: 0
    Last Post: 01-18-2012, 01:36 PM
  2. relationship
    By slimjen in forum Forms
    Replies: 1
    Last Post: 09-26-2011, 07:15 PM
  3. Dynamical diagrams
    By Maddin in forum Programming
    Replies: 1
    Last Post: 06-23-2011, 03:29 AM
  4. Relationship 1:1
    By MrLestat in forum Database Design
    Replies: 1
    Last Post: 05-18-2011, 07:13 AM
  5. Relationship
    By ClownKiller in forum Database Design
    Replies: 13
    Last Post: 12-21-2010, 05:49 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums