Hello, just looking for some general thoughts / being pointed in the right direction.
We are a music school and manage our student database via FileMaker. We have a local server and a number of clients for admin staff. Enrolments are done via a website form which populates a remote mySQL database.
I'd like to see Filemaker talk directly to the mySQL database to retrieve the enrolments. The FM interface would:
- only retrieve data since last import
- allow for viewing and editing of data before importing into local DB
- process the data to look for duplicate customers and enrolments, so that the correct decisions can be made around "creating new" or "adding to existing"
I realise this is complicated, but some 'ballpark' suggestions would be welcome. Thanks.