Data Validation via Script; compare single field (many words) to Multiple records.
This is an interesting one and one I it may have come up before, however I am either searching the wrong terms or it hasn't been posted yet.
Here is what I am trying to achieve;
Table 1 : Activity Table.
Field needing valiation : "Details" (text)
Example of Details :
"Called the customer today and informed him of changes"
Table 2 : validation table.
Multiple records in 2 fields : Entry and Relation
example of data in validation records;
What I want to do:
I would like to run a script that compares the "Details" to all "entry" data in the validation table...
I.E: If "Details" contains any of the records in "Entry", show dialogue box with options.
In this case:
"Details" contains "call" (called)
dialogue box "Mark this activity a Phone Contact?"
I realise I may be missing something very simple here, but I am at a loss.
Cheers in advance for any advice.