R
Ron
Hi,
I'm trying to update a table with values in another:
UPDATE [Stock Report] SET [Stock Report].Name = (SELECT [Status Assigned
Work].Name
FROM [Status Assigned Work] WHERE [Status Assigned Work].[Serial No] =
[Stock Report].[Serial No]);
I get a error message that the operation must use an updateable query!
Both tables have the same primary key and are not referenced by foreign
keys.
Any help much appreciated.
Regards,
Ron.
I'm trying to update a table with values in another:
UPDATE [Stock Report] SET [Stock Report].Name = (SELECT [Status Assigned
Work].Name
FROM [Status Assigned Work] WHERE [Status Assigned Work].[Serial No] =
[Stock Report].[Serial No]);
I get a error message that the operation must use an updateable query!
Both tables have the same primary key and are not referenced by foreign
keys.
Any help much appreciated.
Regards,
Ron.