AnsweredAssumed Answered

I am trying to use a calculation to find a record that contains defined text

Question asked by melbury on May 1, 2012
Latest reply on May 6, 2012 by melbury

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