Find request equals value from another table
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.