I'm using filemaker 10. Is it possible to add a record and update 2 database at the same time. I mean I'm using a database in filemaker as well as SQL. So when I add a record, the data will be added to both filemaker and SQL. Is it possible?
you could either use script trigge to react on adding new records, or on changing data, to write the filemake records via odbc to your sql server.
or you can make an external data source that connects filemaker via odbc as a grafical front end to your sql server. but in this case filemaker doesn´t store a local copy of your data, it will only display it.