Simplified: I have two tables and want to pick/lookup/peek a value from TableA to TableB when scripting. I have a key. I have read about the functions but can't get which one to use and how to use them.
I tried this...
Field1 As MyKey,
Lookup(Value, Key, MyKey, TableA) As ValueFromTableB
I would like to accomplish a load where I can get the value from table B depending on which key I have in the current record from MySource.
Applymap is a good idea, but the only problem could be if there are more than 2 column in the table we are looking the value from. So if there are only 2 columns in Table A (as provided by OP) then I would definitely vouch for ApplyMap, but if there are more than 2, ApplyMap can't be used without doing a Resident Load of the data into a table which only has two columns.