Omiting records after a search
I have a number of tables in a file related by a Client ID number. The original table contains info about a client and other tables contain info regarding support visits etc. I need to find out how i can do a search for different criteria in the other tables and then find out how many clients this relates to. For example, perform a find and then omit any of the records where the client ID repeats itself.
Is there a simple way to do this, either as a 'modify last find' or by inserting a script?.