Re: Migrating from Filemaker 5.5

[Augustina Blair]

Are the users currently accessing the UI via FileMaker or via the Web?

If they are accessing it via FileMaker, you could create a FileMaker UI and have it synchronize with the MySQL database. The ODBC connectivity in more recent versions is pretty decent. You would essentially treat it like a web app - have it execute a SQL query when the user opens the Filemaker screen to select data, and have them submit their changes to the database when they are done. I did this for a system managing user accounts where users could update their info from a web page and internal staff needed to perform other tasks on the data.

For web, you can use a WYSIWIG editor like Dreamweaver to create your pages, and then use a scripting language like PHP to interface with the database. For fancy UI tricks you might need to use JavaScript. It's not quite as easy as FileMaker, but probably works a lot better than Lasso.