My experience with FileMaker goes back to 1985. At the time, I'd brought the first Macintosh and LaserWriter into the consulting company where I worked, primarily for desktop publishing of software manuals via PageMaker, and I wanted to use the LaserWriter to print mailing labels for shipments. At the time, FileMaker was limited to single tables; it was good enough for a simple mailing-label database but could not relate customer records to order records. I think I moved the process to a PC database fairly quickly, even though the PC had only a daisy-wheel printer.
A few years ago, a client asked me to generate a Web site from his FileMaker Pro 5 database on Windows. I couldn't see how to do that using FileMaker's report generator, so I wrote a Python script to read the FileMaker database via ODBC (Open Database Connectivity) and turn each record into a Web page. That worked pretty well, so the client requested I do something similar for another database. Unfortunately, many of the records in the second database were truncated in the process, which turned out to be the result of a bug in the ODBC driver.
As a work-around, we dumped the FileMaker database into CSV files and loaded it into Access; the Python program then generated the site from the Access database. The client loved FileMaker for editing and maintaining the data and refused to switch to Access, so the multistep process for regenerating the site had to remain and was carried forward at least to FileMaker Pro 7. (FileMaker Pro 10 has a newer ODBC driver, but I haven't yet tested it against the old databases.)
FileMaker Pro 5 and 7 looked to me very much like the Mac FileMaker I'd used in 1985, albeit with greatly improved capabilities. FileMaker Pro 10, on the other hand, looks more like Safari. When I first saw the new interface last December, I admired its appearance and the way it put functionality where the user and developer could see it, but I worried that die-hard FileMaker developers would find their fingers going to the old places. According to several of these folks that I queried recently on Twitter, that hasn't been the case; they have adapted easily to the new interface.
Which SKU do you need?