I am looking for a way to complete a one way synchronization. I have a SQL database containing all the equipment that we have out on rental. I Update the Filemaker database nightly with a Perform Script on Server. It works wonderfully but I cannot figure out how to delete the records from the Filemaker database that have been deleted in the SQL database. This script works perfectly except when fired up with a Perform Script on Server.
Import Records (with dialog:Off; DSN; ............ Update matching; Windows ANSI]
Show Omitted Only
Delete All Records [with dialog:off]
Is there some way to make a one way sync work?