Record importing by using script (Current date)
I am current working in a hospital. And i am handling a file maker database (using filemaker pro 11) with over 200,000 record for patient information. This database is currenting link with a SQL database. I used to import the lastest patient information by using ODBC. As the database have over 200,000 record inside, i am used to delete all the record in the filemaker database and re-import whole SQL server data into filemaker. it is time consuming. My ultimate aim is to import lastest patient information (New admitted patient ~ current day). How can i write the importing script?