Hi, I'm sure this should be easy but I just can't work how to do it and I'm at the end of my tether!
I have 2 related tables
the first contains a text field called candidate ID and has contents such as "WKT-021-008" .I have another field in this table I want to populate with a result if I can find (lookup) the candidate ID from this record in another table
My other table has many fields including one 'LocationName' that 'may' contain the text I'm looking for; and this field/records need to be searched - Note location of my 'search text' within the text string is not consistent. e.g may be found in "WAIRAKEI STORAGE (WKT-021-008-A)" for example or variants of this.
My preference would be to return the 'location ID' field from my second table where a location name that contains my Candidate ID and enter this in my first table to show that this location already exists; if not the field will show text "not found"
Can anyone point me in the right direction? Hope this all makes sense.
Thanks in advance