I have done some development using Access and am now switching to the Mac and learning Objective-C. I am also new to programming with databases, so I don't have all the lingo and knowledge to fully express my question. I have primarilly programmed in C on a UNIX machine and Visual Basic for applications in Excel and Access to do data storage, retrieval, and processing.
Question: Can a developer use FileMaker Pro as an underlying database to develop a stand-alone application for data management, query, analysis, and alteration? For instance, though I haven't done this, can a stand alone application get a query from a user via a form window, send a query command (in SQL or other language) to the FileMaker Pro database and receive the desired data back for proprietary use in the stand-alone application? And vice-versa, can the stand-alone application receive new data via a form window and send it to the FileMaker Pro database to update or add records? A real world application of this would be, in a health study, we send out questionaires and receive them back. We want to put the data in and run a
statistical analysis. My application would bring up a form for data analysis, then the user would issue a command to do a statistical analysis. The program would go to the database file, retrieve (for this example) age and weight information, run the statistical analysis, and then display the summary statistics. Is FileMaker Pro able to do this? And if so, is there a book describing how this process can be done in the Mac environment? If not, is there a better option?
Thank you for any help and insight you can provide.