I have a part numbering database written by an engineer with whom I no longer work. I want to change the current numbering structure from XX-YYY-ZZZZ to XYZZZ removing one X, Y & Z as well as the dash components. The XX component belongs to a product ID table, the YYY component belongs to a group ID table and the ZZZZ component is a sequential component of the partnumber table.
Can this be done with minimal modifications? I am capable of changing the form layouts.