Many Records

[mouseman]

Hi,

I have an 11 table Database all relating to "Student Information" SSN (primary key). The rest of the tables have SSN also, but i don't have a primary key field in any of those tables. However, i have all the tables relating as an outer join to "Student Information" (SSN) in the Relationship Window. When i create a multiple table query with three or more tables i obtain many records. I am not sure why i am getting many records. I have a join between the tables or query. Also all the join properties are the same. I still not sure whats wrong.

Thanks for your help!

 

[lespaul]

you may want to read up on joins:

Understanding SQL Joins

what kind of information are you storing in the other tables?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design