Query help please!

[Golfinray]

SELECT [District Special Table].District_Id, [District Special
Table].District_Name_Long, [WA Capital Projects Special].CP_Scope, [WA
Capital Projects Special].CP_Status_ID, [Building
Special].Building_Name_Long, [School Special Table].Long_Name, [Capital
Project Category Special].CP_Category_Description, [Capital Project Status
Special].CP_Status_Description
FROM ((([WA Capital Projects Special] INNER JOIN [Capital Project Category
Special] ON [WA Capital Projects Special].CP_Category_ID = [Capital Project
Category Special].CP_Category_ID) INNER JOIN [Capital Project Status Special]
ON [WA Capital Projects Special].CP_Status_ID = [Capital Project Status
Special].CP_Status_ID) INNER JOIN ([District Special Table] INNER JOIN
[Building Special] ON [District Special Table].District_Id = [Building
Special].Building_Id) ON [WA Capital Projects Special].District_ID =
[District Special Table].District_Id) INNER JOIN [School Special Table] ON
[WA Capital Projects Special].School_ID = [School Special Table].School_Id;

This is the sql of a query that I have. The problem is it is not editable,
in other words at the bottm there is not the arrow and asterisk that allows
you to add records. Therefore, my form from this query is not editable
either. I have done everything I know to do, tried every type of join,
rebuilt the tables and query a dozen times. The tables came from linked
tables on ODBC sql server but I even copy and pasted them and made them
local. All the tables are editable and if I add the tables to the query one
at a time, the query is editable. I'm at my wits end. Help! Thanks!!!!

 

[Stefan Hoffmann]

hi,

This is the sql of a query that I have. The problem is it is not editable,
in other words at the bottm there is not the arrow and asterisk that allows
you to add records. Therefore, my form from this query is not editable
either. I have done everything I know to do, tried every type of join,
rebuilt the tables and query a dozen times. The tables came from linked
tables on ODBC sql server but I even copy and pasted them and made them
local. All the tables are editable and if I add the tables to the query one
at a time, the query is editable. I'm at my wits end. Help! Thanks!!!!

Check if all these tables have a primary key, and that Access/Jet knows
them. Open the linked tables and look for the primary key symbol.

Check if all primary key fields of all your tables in your query are
part of the SELECT field list.

And last, but not least, ok at least, the JOIN conditions must return an
unambiguous set of rows.


mfG
--> stefan <--

 

[Golfinray]

I had a table with no primary key assigned. That did it Stefan, thanks a bunch!