query report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Rosemary,
A primary key cannot, by definition, have duplicates. You may need to
change the structure of your database.
 
Back
Top