Re: Delete record in a join query

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

michael wrote: 
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 
.