If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Help: Primary key and SQL statement
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 |
#2
|
|||
|
|||
Access Help: Primary key and SQL statement
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] |
Thread Tools | |
Display Modes | |
|
|