problems with dublicates

Hello,

We have created a database where we run a query and make a table in which we find dublicates (dublicates-function at queries; meaning we have 3 fields, i.e. pupils and instruments which all have been allocated to a teacher --> we set primary keys for all 3 of them). However, we still have this problem that many teachers are allocated to one pupil. How can we delete dublicates in a way that - whenever we update the query/table - that we don't have to delete the dublicates again? Is there any function in Access?

In addition, is there a function in which Access automatically deletes 2 of the 3 dublicates (for example)?

Thank you very much in advance!

Martina & Nicole & Andrea

If I understand you right you only want a one teacher per pupil per instrument taken

CHange you table structure to reflect

(PK) Pupil
(PK) Instrument
TeacherID

This will allow a student to learn more then one instrument, and will only assign the teacher once to a student/instrument combination.

If this still isn't what you want, then you will need to move the teacherID into the student table to state that this student is only taught by this one teacher for all instruments the student is learning.

If I still haven't asnwered your question, post your current DB and I will look at it specifically, instead of going by memory.

S-