MikeAngelastro
Registered User.
- Local time
- Today, 08:13
- Joined
- Mar 3, 2000
- Messages
- 254
Hi,
I'm trying to run the following query:
"UPDATE Inventory INNER JOIN qryItemReorderPoints ON Inventory.[Item Number] = qryItemReorderPoints.[Item Number] SET Inventory.[Reorder Point] = qryItemReorderPoints.ReorderQuantity;"
But I keep getting the message "Must be an updatable query."
Checking KB Article 328828 has all the conditions that would cause this message but this one doesn't fit any mentioned in the article. The join is a one-to-one and there should be no ambiguity. I don't want to have to create a cursor to do it. Any ideas?
Thanks,
Mike
I'm trying to run the following query:
"UPDATE Inventory INNER JOIN qryItemReorderPoints ON Inventory.[Item Number] = qryItemReorderPoints.[Item Number] SET Inventory.[Reorder Point] = qryItemReorderPoints.ReorderQuantity;"
But I keep getting the message "Must be an updatable query."
Checking KB Article 328828 has all the conditions that would cause this message but this one doesn't fit any mentioned in the article. The join is a one-to-one and there should be no ambiguity. I don't want to have to create a cursor to do it. Any ideas?
Thanks,
Mike