edit "live" data from MySQL in FM?

[nassoit]

I'm very much a newbie with FM. I've been using MS Access on a Windows machine to make changes to a MySQL database on my web server. Typically, I would used Access by creating linked tables, viewing and editing the data "live". I now work on a Mac with FM7 (no longer have access to Access).

What would be the easiest way to set this up in FM7? I have the odbc driver from Actual Technologies and am able to connect to the MySQL database with no problem.

What I want to be able to do is... see the entire pricing table (this is an e-commerce website database) and be able to make changes to the "live" data, without having to push-pull. Is this possible.

Please excuse my lack of knowledge, I'm just a hack web designer trying to learn a few new things. thanks!

- peter

[Wim Decorte]

No, you'll need to push & pull.