ok so Filemaker Server 14 host the database but the layout/schema has to be done in filemaker pro 14 is that correct or old like filemaker 12?
You can use any version of FMP/FMPA that has the .fmp12 file format. So basically 12/13/14
we currently run filemaker pro 11 so can I just get an upgrade instead??
FileMaker 11 files will not work with FileMaker Server 14. You need to buy application version 14, then convert your 11 file(s) to 14. Then you need to purchase server 14 (if you need a FileMaker Server) because the new 14 file will not work on any server below version 12.
yes I know I was asking can I do upgrade from 11 pro to 12 pro or 14pro
Sure you can. It does involve a file format change so there may be some conversion tasks (like getting updated plugins, removing any hard coded references to ".fp7" in your scripts...)
Retrieving data ...