Probably wrong category but anyway ... I've done a couple of inventory control systems and, for every article I usually have a unique id number, given by the system, which is usually invisible to the user, and also a user assigned part number.

Because of the fact that the user may change this part number, I base all my reports and query for operations involving a given part, on my system assigned unique id. I'm starting a new one and was wondering if this is the best approach.

I know my new client is gonna be changing his part numbers, they asked me for a part number history tracking.

I'd appreciate if you guys shared your experience with me, TIA