I would like to connect to another database from FileMaker Pro (we have FMP clients and a FMP server). I don't know what the other databases are build on (proprietary) or what protocols they have, yet.
I know FMP can do ODBC which is said to be not very secure. What other protocols does FMP have to connect to other databases? What information do I need from their group to quarry records based upon a field and pull data from that record to populate the fields we need filled out in FMP?