I throw a different idea out, though it does have the issue of confusing interface until you reload the manage parts interface where two parts will be showing the same label, when in reality one of those two no longer exists.
With that SQL loaded into the database if you rename a part to the same name as a different part on the same record the two should automatically merge. Otherwise the rename goes through without merging.
This is based on code I originally wrote to "correct" parts at MVLC.
I throw a different idea out, though it does have the issue of confusing interface until you reload the manage parts interface where two parts will be showing the same label, when in reality one of those two no longer exists.
http:// pastebin. com/6jtHXkn3
With that SQL loaded into the database if you rename a part to the same name as a different part on the same record the two should automatically merge. Otherwise the rename goes through without merging.
This is based on code I originally wrote to "correct" parts at MVLC.