I did not look further at the autonumber in the LK* tables. I could if there is a need, but I don't see it yet.
Since there is no autonumber field in those tables, it could be inserted when you are processing. However, if you are constantly refreshing things then better to automate up front.
For the preliminary mapping, I chose some key strings to select "candidate records/injury types" into groups.
I ended up with 16 groups and mapped all 160 records.
I'm attaching the LK_INJURY_TYPE with the mapping identified in the comment field. The Mapping show which of my queries matched. (But the value may depend on the order the queries are run where keyword from >1 query was found).
So, I suggest you look at the groupings and check for some consistency. Then, see how you would map the queries/groups to the new target injuryType. As I said the groupings were meant to reduce the 160 to a smaller set for mapping to new target.
Once changes or approach is identified, I'll adjust the database and forward it to you.
I also tried to break each old injury type into fragments and same for the new ones, then tried to match fragment to fragment.
Quite frustrating --really only got a handful of hits/matches and most of those were on things like "and", "the". So I restricted possible mappings to at least 4 characters and got this list (not very helpful in my view). This didn't seem helpful to me without
a lot more work.
aold(i) CONDITIONS ~map ~ anew(j) Conditions
aold(i) CONDITIONS ~map ~ anew(j) Conditions
aold(i) system ~map ~ anew(j) System
aold(i) system ~map ~ anew(j) System
aold(i) system ~map ~ anew(j) System
aold(i) system ~map ~ anew(j) System
aold(i) system ~map ~ anew(j) System
aold(i) contusion ~map ~ anew(j) Contusion
aold(i) Dislocation ~map ~ anew(j) Dislocation
aold(i) foreign ~map ~ anew(j) Foreign
aold(i) Foreign ~map ~ anew(j) Foreign
aold(i) Fracture ~map ~ anew(j) Fracture
aold(i) contusion ~map ~ anew(j) Contusion
aold(i) wound ~map ~ anew(j) Wound
aold(i) Hearing ~map ~ anew(j) Hearing
aold(i) nerves ~map ~ anew(j) Nerves
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) multiple ~map ~ anew(j) Multiple
aold(i) superficial ~map ~ anew(j) Superficial
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) injury ~map ~ anew(j) Injury
aold(i) fracture ~map ~ anew(j) Fracture
aold(i) wound ~map ~ anew(j) Wound
aold(i) Respiratory ~map ~ anew(j) Respiratory
aold(i) Respiratory ~map ~ anew(j) Respiratory
aold(i) respiratory ~map ~ anew(j) Respiratory
aold(i) respiratory ~map ~ anew(j) Respiratory
aold(i) Respiratory ~map ~ anew(j) Respiratory
aold(i) Respiratory ~map ~ anew(j) Respiratory
aold(i) FOREIGN ~map ~ anew(j) Foreign
aold(i) dislocation ~map ~ anew(j) Dislocation