I haven't done this myself, but the documentation indicates you can use Filemaker as your front end and link to SQL Server via ODBC for the back end. Others here on the forum have set this up successfully, I believe.
Thank you very much for taking the time to respond.
I have been researching this for a little while and what I can't put my finger on is whether or not I can develop a solution that uses FileMaker as a "front end" application while having ALL the data reside in a SQLServer database. As you said it "appears" that you can but I guess I will just have to download the free trial and try it for myself. I was just hoping that someone in the FileMaker community had already done this and could tell me what to watch out for - there is always something to watch out for!
Thanks very much!
Although FileMaker makes it known that ESS is not to be used as a complete front end to an external source, indeed it can do a lof of things to do something similar. There are indeed limitations though. As a general rule of thumb, allow the heavy processing to be done on the SQL side.
Thanks very much for the heads up!
This is exactly what I was worried about - as I said there is always a gotcha!