FileMaker Find and Delete

Scripting Forums AppleScript | Mac OS X
#1

I’m having some trouble manipulating records in FileMaker Pro Advanced and wondering if anyone can give me advice on the following script.

What I want to do is:
–Find a title by name
–Delete the record from the database

What I can’t seem to do is get a reference to the record and then simply delete it.

Here is what I have:


use AppleScript version "2.4" -- Yosemite (10.10) or later
use scripting additions

set delBooks to {"Nineteen Eighty-Four", "Animal Farm", "Coming Up for Air", "Burmese Days"}

repeat with i from 1 to count of delBooks
	set bookTitle to item i of delBooks
	tell application "FileMaker Pro Advanced"
		tell database "bookLibrary"
			tell table "Books"
				delete (every record whose cell "Book Title" is bookTitle)
			end tell
		end tell
	end tell
end repeat

Does anyone have a script that does something similar? This seems like such an easy task.