We help IT Professionals succeed at work.
Get Started

Problem re- establishing a relationship

mjburgard asked
Last Modified: 2015-09-08
Somebody did some editing on the Access Database over the summer and messed up the relationships I had in it.  I had to create a new table (columns ClassnumberN (key), Classnumber, ClassPrefix).  I have a numbered field (ClassNum) in a table called Appointments that I use to reference this table so we can keep track of which class a student is seeing my office for help in.  My problem is now with the relationships.  I created a one to many relationship between the two tables, but if I select a class for one student, it changes the classes for all of the students in the database.  I am fairly sure this is a referential problem, but this was not how it was working when I left for the summer.  
I am having trouble finding the issue.  Any help would be appreciated.  (I am trying to avoid recreating the entire database and importing the data.
Watch Question
Distinguished Expert 2017
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE