Avatar of mjburgard
mjburgard
Flag for United States of America asked on

Problem re- establishing a relationship

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.
Microsoft Access

Avatar of undefined
Last Comment
mjburgard

8/22/2022 - Mon
PatHartman

Please post a picture of the relationship diagram.  Make sure we can see the relevant parts.
mjburgard

ASKER
relationship.png
mjburgard

ASKER
I was looking at the properties for this field in my form, shouldn't this be bound my the variable I am looking up?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
PatHartman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mjburgard

ASKER
While this was not ultimately the solution it did help me get there with a some other good advice that helped solve some things.

The problem has been resolved by finding a recent backup and restoring it then entering the 30 or so entries that needed to be restored by hand.