I've tried to use the syntax:

set myRecs to (every record of table "mytable" of database "mydb.fp7" whose cell "myCell" = "something")

But all of the time I found it not working or not working all the time.

Could anyone share the correct syntax and or the tricks for me to feel confident to use this way of accessing the tables.

If you in the tell clause just writes:

tell applicatio....

      databases

end tell

Will you realize where your code is too abreviated, could instead be done this way:

tell application "FileMaker Pro Advanced"

	set theCorrectBase to database "mydb.fp7" of application "FileMaker Pro Advanced"

	set myRecs to (every record of table "mytable" of theCorrectBase whose cell "myCell" = "something")

end tell

But I wonder how relevant such endeavors really are, enlighten us???

--sd