I am fairly new to FileMaker Pro Advanced so i am looking for some sort of guidance.
I have a lengthy list of software which I have imported from an excel sheet into FM. I want to keep only unique values/records(from same field) in the list. I know I can use the find module and use the "!" command to find duplicates and delete those records but that deletes the unique values as well. Can anyone assist on this matter?
Also when i use the find module and use multiple find requests for one big find made of about 3 different find/requests, the preceding find request always seems to omit.
Please assist if able