Jason,
Thanks for the clarification, your scheme is certainly clearer to me now. I have a suggestion for you based on you implementing a PDM in the near future. Why not just use your part number DB to give/track the base number only, i.e. 000003, 000004, 000125, etc.? Leave off the .XXX seeing...