ODBC Filemaker to MySQL

[Fungyo]

I'm a bit of a newbie when it comes to ODBC, so I will explain what it is I'm trying to achieve.

What we will have is a Filemaker Pro 9 Advanced database locally hosted on an internal (our LAN) server and a remotely hosted MySQL database which is hosted on a remote server.

The two databases will be identical.

The MySQL db will be used with our on-line reservations processing, it will store customer details temporarily, will use stored rates data to make booking calculations and also deliver content to our product info pages.

Product rates and info will be updated on the Filemaker db. all updates to products on the Filemaker db need to be reflected on the MySQL db in real-time.

Customer reservation details are entered into the MySQL db from our on-line forms.

Customer reservations details are retrieved and removed from the MySQL db and transferred to the Filemaker db in real-time.

Basically the Filemaker database will be used (i think) as an external source to the remote MySQL db.

The only time this will be different (I think) is when retrieving customer details from the MySQL db.

Does this make sense?

Can we implement something like this?

Does anyone have any guides, tutorials etc that will help me achieve this?

Thanks.