Is it possible to make a script that creats a field with the value in the result column? I want to find out if we have done something with the same sort code for the client before.
If ClientNo and Sort code is the same on a older matter the answer should be No.
You need for this a resident-load of your table with a sorting on ClientNo and SortCode and could the use peek() or previous() to check the current record-value with a previous one: Peek() vs Previous() – When to Use Each
