Query not updateable - SQL attached

[Guest]

Can someone look at this and tell me what I should do to make my query
updateable. Thank you!

SELECT [Quality Alert Table].Mld, [Quality Alert Table].Coat, [Quality Alert
Table].Assy, [Quality Alert Table].Service, [Quality Alert Table].[Quality
Alert #], [Quality Alert Table].[Quality Alert Title], [Quality Alert
Table].[Customer Concern #], [Quality Alert Table].[Issue Date], [Quality
Alert Table].[Expiration Date], [Quality Alert Table].Program, names.Name,
[Quality Alert Table].ID, names.ID
FROM [Quality Alert Table] INNER JOIN [names] ON [Quality Alert
Table].[Quality Alert #] = names.[Quality Alert #];

 

[Guest]

Is the Quality Alert # field in either the Quality Alert Table table or names
table a primary key? If not, that can make it unupdateable.

Also if you go to the Relationships window are the two tables joined with
Referiential Integrity enabled? It should be if you want it updateable.

Probably the best way to handle this is first make sure that one table has
Quality Alert # field as the PK then join the two tables in the
Relationships window with RI. Next create a form out of the table with the PK
Quality Alert # field. On that form put a subform with the other table. The
wizard should easily figure out how to keep things joined as it looks into
the Relationships window to create joins.