Making a Queary Updatable

[Sorting in a Graph]

I can not seem to make the following query updatable. Please help:

SQL view:

SELECT Projects.*, Projects.[Year of Project], [Business Units].[Sort
Order], Projects.[Project name]
FROM Projects INNER JOIN [Business Units] ON Projects.[Business Unit] =
[Business Units].[Business Unit]
WHERE (((Projects.[Include in Slide Show])="Yes"))
ORDER BY Projects.[Year of Project], [Business Units].[Sort Order],
Projects.[Project name];

Thanks.

 

[Allen Browne]

You have 2 tables - Projects and Business Units - related via share a
Business Unit field.

In one of those tables, you must have a unique index on this field.

For example, you might make it the primary key of the Business Unit table.

If that is not the issue, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
but I'm guessing it's the 8th issue.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...