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.
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
Last Comment
mjburgard
Please post a picture of the relationship diagram. Make sure we can see the relevant parts.
ASKER
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?
ASKER CERTIFIED SOLUTION
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.
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.
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.