Delete record in a join query

[michael]

Table tblClass Table tblStudent
-------------- ----------------
Class Student
ClassName StudentName

Table tblClassStudent
---------------------
Class
Student

Query qryClassStudent
---------------------
Class
Student
StudentName
From
Table tblClassStudent
inner join
Table tblStudent
on tblStudent.Student = tblClassStudent.Student

The reason for the query is to show the user the StudentName.

I delete a record in qryClassStudent and the query deletes the record in
tblStudent. Referential integrity is on but cascading update/delete is
off. Relationship is 1-1.

I want only to delete the link between Class and Student, not the
records in tblStudent.

Thanks

 

[michael]

Please ignore this post. The 1-1 relationship was causing the problem.
Thanks