Connect a field in a FM dabatase to a field in an ODBC connected database.
I'm relatively new to this whole arena, both database work and Filemaker as a whole. Most of the work seems pretty straightforward, at least for the basics, but...
I'm sure this is largely a matter of ignorance on my part, and also that my book hasn't gotten here yet, so I must bug you good folks with a n00b question.
I'm trying to pull data from a MySQL database to a field in a FM database via ODBC. Let's say I have a field 'Email'. When a record is pulled, I am hoping to get the Filemaker database to query the Email field for a given record in the MySQL database.
I have been successful in connecting via ODBC to to MySQL database, at least it shows up in Manage Databases.
Can someone either give me a rough idea where to start or a decent tutorial/primer on this?