Vendor Duplicate check - why is only Name1 included
Name1 and Name2 both exist on the payment_tbl which means checks (payment) can be created that have both names on it.
Name fields are only 40 char long and a huge portion of our vendor names spill over to Name2, which causes them to be rejected as duplicates since the "difference" in names is in Name2. Any ideas?