Results 1 to 5 of 5
  1. #1
    Shekee is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    1

    Help! I have messed up what was suppose to be simple relationship database


    Nothing is working. I was aiming to take my main customer table with customer information relate it to the Yoga table and display the Yoga class name and all the people who registered for that class and take the Instructor Name and list all the people who registered for their class. But nothing shows up in my reports. Is anyone available to take a look? I have been on this for a week and no progress.
    Attached Thumbnails Attached Thumbnails Customer Registration.png   Yoga Classes.png   Yoga Instructors.png   Relationship.png  

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Perhaps the relationship between Customer table amd Yoga Classes should be between the two fields called CustomerID
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I think your problem is caused by lookup field for the Instructor ID in Yoga Classes table (try to remove the lookup - you can use a combo box in the form to display the name instead of the ID). Also in the last pic you have linked the wrong fields - you should have linked ClassName from Customer Registration (not Customer ID) to ClassName in Yoga Classes. A better design would have had the ClassID (number- long integer) in Customer Registration instead of using the text ClassName and the link would be between the ClassId fields.

    Cheers,
    Vlad

  4. #4
    Nikki Harry is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2018
    Location
    Manila
    Posts
    13
    Hi Shekee, I feel your pain (I'm in the same boat). I just wanted to ask; Phone numbers and email addresses. It's example data only, right.

  5. #5
    Join Date
    Apr 2017
    Posts
    1,673
    tblCustomers: CustomerID, Cust_Forename, Cust_Lastname, Cust_Email, Cust_Phone;
    tblInstructors: InstructorID, Instr_Forename, Instr_Lastname;
    tblYogaClasses: ClassID, ClassName;
    tblClassInstructors: CIID, YearNo, ClassID, InstructorID;
    tblClassCustomers: CCID, YearNo, ClassID, CustomerID.

    Instead YearNo may be something like CourseNo.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-10-2017, 07:52 PM
  2. Simple Database Relationship Questions
    By dbmiller5 in forum Database Design
    Replies: 4
    Last Post: 07-18-2016, 12:20 PM
  3. Replies: 1
    Last Post: 06-13-2016, 03:05 PM
  4. Establishing a simple relationship?
    By Harry2 in forum Access
    Replies: 7
    Last Post: 06-16-2014, 02:41 PM
  5. Back from Vacation to find my database messed up
    By imintrouble in forum Access
    Replies: 4
    Last Post: 04-05-2012, 04:52 AM

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