Update field in one table with value from field in another...not linked

[PasJes]

I have a table that contains makes and models of cars. Call it table 1.




I have another table that contains a single field that has the year, make, model and a bunch of other stuff in a single field. Call that table 2.


What I'd like to be able to do is to loop through table 1 and see if the model is contained in any of the records in table 2.


So say for example, the first record in table 1 is make = Volkswagen. Model = Golf.


I want to run through every record in table 2...find where a part of the single field matches "Golf" and if so, add that value to a new field called model (which I will create).


Does that make sense? Probably haven't explained very well.

[Bob Fitz]

I would recommend that you normalize your db first. See e.g. https://learn.microsoft.com/en-us/of...on-description

[PasJes]

I would recommend that you normalize your db first. See e.g. https://learn.microsoft.com/en-us/of...on-description

I can't really. The data in table 2 is provided to me every day from an external source.

[Bob Fitz]

I can't really. The data in table 2 is provided to me every day from an external source.

In that case I would create a db with normalized tables and then concentrate my efforts on manipulating that daily data into the correct fields, in the correct tables.
A poorly designed db will cause you no end of headaches going forward.

[ArviLaanemets]

There are different models of e.g. VW Golf available (+ some of those models have different names in different countries). VW Golf GTE, VW Golf GTI, VW Golf GTD, VW Golf R, VW Golf TSI, VW e-Golf, etc. So when you have only "Golf' to search for, how do you decide, which one? Or will be VW Golf family be enough for you?

Generally for getting such info from field, you have to search for a string in field. When the position of this string is >0, the record does match, when =0 then it doesn't match. There will be problem, when the string you search for is not uniform (like VW Golf GTE or Volkswagen Golf GTE) - when this is the case, the search will be more complex (you have to search for all possible combinations), or even impossible (e.g. the producer is missing, and the search will match for several producers).