AnsweredAssumed Answered

Find request equals value from another table

Question asked by chadmccomas on Oct 20, 2013
Latest reply on Oct 21, 2013 by philmodjunk

Title

Find request equals value from another table

Post

     I have a question.  I'm writing a script where I want to check whether or not an area code in Table1::Areas exists in Table2::Areas.  

     In the Edit Find Request, I chose  Find Records When:   Table1 Areas 

     Criteria:  = Table2::Areas

     But this just literally searches for the characters "Table2::Areas"

     How do I do this?  Essentially, if it does find a match, i want it to Omit the records and then delete all remaining records when it is done.

     Thanks!

Outcomes