AnsweredAssumed Answered

FileMaker as Front end to MSSQL database

Question asked by kdefilip on Mar 8, 2009

Title

FileMaker as Front end to MSSQL database

Post

Hi

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?

Outcomes