Updating a field from a secondary database
Forums
I am trying to accomplish the process described below. I tried it by adding a new field to the master db and doing a database lookup on the wildcard table. The lookup was successful but I was not sure how to get the value from the wildcard table to add to the new field. I should have kept the code to post. I believe I needed to get values from two tables but could only get them from one.
I also am working on a loop that loops through the master and for each record it loops through the wildcard. I believe that will work but will be more inefficient than the 1st way.
Any suggestions.
Thanks,
Randy
Fuzzy Match was one of the
Fuzzy Match was one of the first things I considered and dismissed. I gave it another thought look and believe it is the way to do it. By the time I build the "wildcard db," it will be close enough for it to work. I just overthought the problem.
Thanks for the help.
Randy
Hi Randy, have you looked at
Hi Randy, have you looked at the fuzzy matches within IDEA as that might help you out. Here is a vidoe on address but I think it is the same priciple as what you are looking for.
https://www.youtube.com/watch?v=Lu3mwVqE-G4&list=PLEE1l8LoXUCLS2GYi5Qsv…