Link to home
Start Free TrialLog in
Avatar of mjburgard
mjburgardFlag 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.
Avatar of PatHartman
PatHartman
Flag of United States of America image

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

ASKER

User generated image
I was looking at the properties for this field in my form, shouldn't this be bound my the variable I am looking up?
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.