4 Replies Latest reply on Apr 8, 2009 10:27 AM by user14691

    Filemaker External Database Searches coming back incorrectly

    user14691

      Title

      Filemaker External Database Searches coming back incorrectly

      Your post

      Software Products Involved:

      Server - Filemaker Server 10 &  ODBC Administrator - Version 1.1.0

      Filemaker Pro 10- Administrator

       

       

      Operating Systems Involved

      Administrator Operating System -  Mac OS X Version 10.5.6

      Server Operating System - Mac OS X Server Version 10.5.6

       

      Description of Problem:

      Our Filemaker databases are currently connected to the mysql tables that we use for our member websites using the ODBC Driver. (Website database system is officially called Community Builder). We have set the records up in filemaker so they each have a unique user id that links them to our filemaker database.

       

      Within the filemaker database we have it set up so the fields from the mysql database or table are the fields that we are using to enter data directly into. ie: first name, last name, address, city, state, etc

       

      So the only fields that are actually originating from the filemaker database are additional items for tracking such as dues payments, conference reg etc.

       

      The problem we are  having is that if we do a find from the filemaker database on one of the mysql fields such as state it doesn't find all of the records it should. For example: do a find using the mysql field for state and enter FL for Florida. We have 287 members in Florida but the database only returns 3 from the find.