Is inventoryID a text or number field? The results you report suggest that it is a number field when it should be text.
Thanks for getting back to me about this. Indeed, for some reason in that table I had set it as a number field, which was the cause of my trouble. It should have been text.
I appreciate you help.