I am using FMP Advanced 15.0.3 with Mac OX 10.11.6 and can't seem to get/set field values of a set of found records, or indeed reference the fields properly. I have a three table database and one table,called Image_Files, has a container field manually set to store an image externally by reference. I can access the field "Image" in every record with the following script but I need to access a found set rather than every record in the table:
--use AppleScript version "2.4" -- Yosemite (10.10) or later
use scripting additions
tell application "FileMaker Pro Advanced"
tell document 1
set AList to field "Image" of table "Image_Files"
count of AList --is count of all records
set theFile to item 1 of A
tell application "Finder"
name of file theFile --correct value
In the above, AList is a list of all records. I need to work with only the found set. I tried to accessing by document and database and by layout and window (both with found set displayed) but got errors when trying to reference records, fields and cells. How does one access a set of found records? Thanks for any insights.