SQL and Filemaker- Getting information about Deleted Records from SQL Database
Posted on 2006-05-10
I'm using an SQL database to record information about conference attendees. My Filemaker database utilizes the ODBC driver/plug-in from Actual Technologies to communicate with the SQL database. My Filemaker database checks for records that are modified or added (by utlizing the maximum timestamp) and then downloads/updates those records. The only problem I have is, I don't know how to check for records that have been deleted from the SQL database. My Filemaker reporting needs to be accurate, which means it would need to exclude records that have been deleted from the SQL database, but how can my Filemaker database know which records those are?