query report

R

Rosemary

I have 2 tables, 1 has 543 records with teachers names & ID# as primary key,
the other 810 records of different types of observations with ID# as primary
key - duplicates checked as Yes. However, duplicates are not coming over.
Teachers names are only coming over once. I need a list of all the
observations for each teacher. What am I doing wrong?
 
L

Lynn Trapp

Rosemary,
A primary key cannot, by definition, have duplicates. You may need to
change the structure of your database.
 
Top