FileMaker as Front end to MSSQL database
I'm trying to build a FileMaker front end to a MSSQL database for reporting purposes. I'd like to be able to do this without pulling every table and record down from the SQL server.
I've been able to connect over odbc, but when I build relationships it seems as though all records are being pulled to FileMaker.
Is there a way to have a user enter search criteria and just issue queries over ODBC and populate report layouts based upon the results?