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.
LVL 1
mjburgardAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Please post a picture of the relationship diagram.  Make sure we can see the relevant parts.
mjburgardAuthor Commented:
relationship.png
mjburgardAuthor Commented:
I was looking at the properties for this field in my form, shouldn't this be bound my the variable I am looking up?
PatHartmanCommented:
ClassNumbersN looks like it is a multi-value field.  I couldn't even begin to tell you if this would work.  Best practice is to get rid of ALL the abomination data types and create standard m-m relationships with visible junction tables that you can control.

Appointments - StudentInfo - can't see the related fields but it looks like this is a pathological relationship.  You have StudentN in the Appointment table and AppointmentN in the student table.

RI is not enforced on any relationship.  Simply drawing the lines does nothing for you.  RI MUST be enforced or don't even bother.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mjburgardAuthor Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.