I am new to the list so please bear with me..:-) We are in the process of creating 2 online forms for collecting data. The plan is to use MySQL to store the form data. After the data is collected in the MySQL DB we are planning to import this data into FileMaker Pro for storage and report generation.
These is my questions:
1. Can we use a FMP database to collect data from the online form directly?
2. Does FMP have a particular GUI template that can be used for online data collection or would it be best to use a standard PHP-type form that users can securely access online and complete the surveys?
Any assistance/insight would be greatly appreciated.