Clean up Item Numbers

Hi Gavin Thanks - yes thought so - hoped MYOB had created a visible field like they do for contacts like RECID. I think this is now a big problem for me as the direct link from 1 file to another is this Item Number - which is important. As a follow on - I built a program that links real time to a web cart, initially, using 'item Number' as the connection. Worked until we found staff creating new item numbers - would leave the inventory window open after creating a new item - come back to it and start typing - go oops and close - what they had done was wipe out or change an item number - ignoring the warning. This rippled through and severed the connection through to the web and ALL past history. Luckily - and NOT BY GOOD DESIGN - in the back of MYOB - the API (by design) has a UID that NEVER changes. Once we linked and used that - problem gone. Why cannot MYOB front end talk to MYOB backend - simple to grab a hidden field that enables this really important updating feature - eg bulk add z to old inventory to push extinct to the bottom. Watch this spot - I am going to do this from the backend and offer this up as a utility - shouldn't be hard - I suspect the 3rd party running on a local file is using a SQLCE driver - which I know exists in Visual Studio but not as a stand alone. I will build it using the API so it will run local and in the cloud - watch this spot - however, this may be a dead duck if MYOB API doesn't allow updates of Item Numbers this way. Thanks