0 Replies Latest reply on Mar 8, 2009 7:05 AM by kdefilip

    FileMaker as Front end to MSSQL database

    kdefilip

      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?