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.

The website encountered an unexpected error. Try again later.