Merge two items in MS POS

I'm new to these newsgroups so bear with my questions: 1. I'm a small business owner using MS POS 1.0 (not RMS) and am looking for help and support. Is this a forum to find other MS POS users? 2. Specific issue needing help on: Items on purchase orders were created, recieved and closed using vendor supplied upc codes which turned out to be wrong. Clerks have been creating new items using the correct scanned upc at time of check out to keep customers happy. Thus have two upc numbers for the same item. Need to link the two together somehow to maintain correct inventory.. Alias doesn't work because POS indicates either number already in use. Any suggestions or directions to some help please? thx.

-- Mr.J

Jeff, Thanks you very much for the lead. I will try it and post the results! I've never played with SQL but the instructions look easy enough and appears to correct the entire process all the way back to the closed PO. Follow up questions if you please: 1. I will use this for the items that have two records created. For those items that we were able to catch prior to a sale, I used the Alias feature to link the wrong and the right upc codes together. I did this because although I could change the upc code for the item, the purchased orders for the wrong upc are already closed and cannot be modified, thus inventory would not be accurate. Do you know if the alias number will tie back to the PO and thus provide correct inventory count?

1. Does MS endorse/support the solution you provided specifically for MSPOS? Perhaps if they are monitoring they can comment. thx.