Vendor Master in one DB and Employee Master in another
dhuffman63
Forums
I'm trying to detect if I have in my ERP database vendor master file (Great Plains) employee names that reside in a different database (Vista/PDS). I tried joining the two on address ID but that didn't work very well. Is there another way to do something like this?
Sounds like you should be
Sounds like you should be doing a fuzzy match. If you have 11.1 go to the IDEA Lab and check out the Fuzzy Match script (there is also a video on how to use it). If you are using an older version here is a video on how you might want to do it manually - https://www.youtube.com/watch?v=Lu3mwVqE-G4