I'm building a 3-table file in fp7 and using Applescript to populate it from properties in Quark. I got the quark part and the filemaker part working.

I have layout "text component" open

and this works:

tell "Filemaker Pro"

tell document "nci07.fp7"

tell layout "text component"

set thisRecord to create new record tell thisRecord

set cell "key" to arbFile

end tell

end tell

but when I add this:

tell layout "text component"

set thisRecord to create new record tell thisRecord

set cell "pgCt" to funfun

end tell

end tell

end tell

end tell

It fails to find the cell.

Obviously, I'm not addressing the right table/layout. I've searched the forums and tried different variations but it only works with one or the other when I manually switch layouts. One set of this will fail. I've tried switching the layouts in the script but they're failing too.

I've tried figuring the properties to get clues there. I've used this:

tell application "FileMaker Pro"

name of cell 1 of layout 1

end tell

to figure out how FM is addressing the layouts/tables. But while I have 3 layouts, only layouts 2-3 are seen. Layout 1 is not.

What would you do, and keeping three tables? thanx, sam

After failing to find solutions that worked in the forums, here's what I found. To switch layouts in AS:

tell application "FileMaker Pro"

tell document "nci07.fp7"

tell window 1

tell layout "component"

go to it

set thisRecord to create new record

tell thisRecord

set cell "key" to arbFile

end tell --thisrecord:component

end tell -- table component

end tell --window 1

end tell --doc 1

end tell --app fmpro

Probably has some bad form in it, but it's getting me over my hump, thanx, sam