Updating a field from a secondary database

randywb

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
 

randywb Fri, 06/30/2023 - 10:01

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

Brian Element Fri, 06/30/2023 - 10:37

Glad to help, it is often good to talk through your project with someone else, many times other thoughts come out in the process.  Good luck with your project.