I have a subroutine finding all matching records and building a list of Record ID (example: 3.5869E+4). Unable to directly go to those records, so I have a clunky work-around of stepping through every record and seeing if that specific record matches. There has to be a better way.

Here is the slow code that brute forces its way through the DB...

--Finds specifc date records in DB. This works quickly and well.

set foundRecords to findSingleDay(simpleDate, "Text DB", "Detailed Layout")

tell application "FileMaker Pro"

--counts entire database (98% worthless data)

set countOfTextDB to count every record of database "Text DB"

end tell

set i to 0

--Repeat with every record in database. Too slow.

repeat with i from 1 to countOfTextDB

tell application "FileMaker Pro"

set potentialrecordID to (ID of record(i) of layout "Detailed Layout" of database "Text DB"

end tell

if foundRecords contains potentialRecordID then

processRecord(i)

end if

end repeat

Is there a way to directly process the found set of records strictly by the unique record ID?

Something like where j is the unique Record ID not the record index...

repeat with j in foundRecords

process record(j)

end repeat

Driving me crazy. Any help appreciated.

Robert

Your request is a little unclear. What are you really trying to do, and why do you not want to really go to the records?