You need to create a way to merge duplicate vendors. The vendor data bases are becoming a mess

We keep getting duplicate vendors in our vendor database, but you can't do anything to clean it up because both duplicates are usually already assigned to at least one job, thus preventing us from deleting them. You guys really need to make a way to merge duplicates and when we do so we should be able to pick with duplicate we want to become the baseline one that all the other duplicates are merged into.