Access Help: Primary key and SQL statement

[Stephen]

Hi,

I am creating a database that includes classroom information, such as:
grades, attendance, etc. I have one table that is called Student information
and the primary key is the Social Security Number. The rest of the ten
tables don't have a primary key because I was obtaining a duplicate error
when I was entering it into the subform. In addition, all my tables have
outer joins and I come up with an error when I create a query. It says: "the
SQL statement could not be executed because it contains an ambiguous outer
joins. To force one of the outer joins to be performed first, create a
separate query that performs the first join and then include that query in
your SQL statement." I am not sure how to create the SQL statement.

I can also send the database to you by email, if you want to look at it.
Thank you

Stephen

 

[TC]

You need to completely stop work on the queries & forms, and go back to
the tables. You can't do anything else successfully, until you have the
tables right. And if some of the tables don't have primary keys, that
is absolutel not right!

For each table, tell us:
- the name of that table;
- exactly what is represented by a single row in that table;
- the names of the main fields in that table, and
- the primary key field(s) (if you've decided them).

Believe me: you are absolutely going in the wrong direction, if you do
not define the proper primary key for each table, /before/ you write
the queries, forms & reports.

HTH,
TC [MVP Access]