Find out whether value in one field exists in another.

[terrusie]

I have two tables: A & B

A has two fields:

[Traffic Signal],

Location

B has one field:

[Traffic Signal Currently Red]

I need to find the Location value for each [Traffic Signal Currently Red]

[sunny_talwar · Accepted solution]

May be use ApplyMap or Join....

[YoussefBelloum]

Hi,

if [Traffic Signal Currently Red] values in table B exists in [Traffic Signal] in table A, I would recommend using a Mapping table and Applymap() to fetch the location values, like suggested by Sunny