Can I do complex SQL Queries through FIleMaker's ODBC?
For example, I want to pull all unprocessed orders and then update the table showing that those orders have been processed.
How can you automate this to happen every day?
Need some guidance here. We are taking orders over the internet and storing the data in a MS SQL Server database server. We need to get the data into our FileMaker database.
The SQL Server is a remote server connected via a VPN. What is the best way to do this? I have tried ODBC with no luck over the VPN. Should we put the data into a local FileMaker database on the web server and then transfer it over?
How about exporting to plain text from sql and then importing that file into file maker?
Any suggestions would be helpfull.
Thanks