If you have many users that will be accessing it through a web interface, then you may need FileMaker server ( or Server Advanced depending on what your needs are ). You only need one copy of Pro Advanced fo development.
If you dont want to build a web interface, then you will need copies of Pro for all your users.
How many users do you have?
There are now 3 and soon to be 4 users.
I have a test db set up using ODBC drivers to access the data (MySQL) on our webserver. It seems to work fine. If I can create a standalone that will work well with the ODBC drivers I see no reason for the others to have their own copy of FM since none of them would have a clue as to what to do with it. Maybe I should clarify that this is a hosted server and not a dedicated computer (server) that we set up.
I don't know what advantage FM server would give me unless it has to do with access by too many at one time. I'm not familiar with the use or need of FM server. Maybe you can enlighten me on that issue.
Well FMS is needed for anything over 5 users on the web. ( IWP )
Now from what you are saying, it seems as though you want to create runtime applications. Runtime applications can not be networked or use ESS to the MySQL db (Technicall there may be ways but it goes against the license). Otherwise, people would just buy one copy of FileMaker Pro Advanced, build a runtime, and use it as a front end to a SQL backend for $500 for hundreds of users.
Thanks, I think I've got it. Guess we will need to buy FMPro for the other users as necessary since it would be a long time before we go over 5 since I can't do exactly what you mentioned, build a front end with Advanced and access the MySQL database via the web. Guess I need to go read the license for all the products. Really a bummer. Or, I have experimented with RealBasic and even though it will take me longer, I can write a standalone front in and access the web database with no problem. I've already tested both FM and RealBasic as a solution and the advantage of FM is quick and easy compared to writing the RealBasic code.
Thanks for the input.