I know ODBC is the beginning to solving my issue, and I am able to connect to my MySQL tables from FM and import my data. My dilema is the automation of the process. Does anyone know FM well enough to give me some tips on how to set up this system so FM will "check" on a cycle for new records? Additionally, I will need to update the MySQL table from FM after importing the records so FM will know the next time which records are new.
Thanks!