My company bought a File Maker Pro Database. We are now out of money to ask for new implementations and I am in charge of making future changes and running reports etc... I am trying to get familiar with the system, my only background is in Access. On the old system I was able to go to the tables and test my own SQL searches that would give me the results I was after when the interface didn't provide those type of searches.
Is there a way I can access that area of the File Maker Pro database where I can run SQL searches and do some testin. My main objective today is to do a search for duplicate emails so I can start cleaning data.
Any help would be greatly appreciative.