Greets, all:

Here's what I want to do script-wise:

1) Compare two FMP files ("Student Records" and "Health Record Card") to see if Student Records has more records than Health Record Card. If they're equal in number the script exits, otherwise...

2) Isolate the 'extra' records Student Records then import them into Health Record Card.

I was in the process of writing the script (attached) but stopped because when I run the script and it reaches the Show Omitted Only step, the command affects Health Record Card but not Student Records.

Why is that happening when FMP is focused on the related record, and what's the tweak I need to fix that? I tried adding a Go to Layout step before Show Omitted Only but again, it's looking at Health Record Card, not Student Records. :S

TIA for your help!

A script runs in a file. If you place the external table on your relationship graph and create a layout for it, your script can then address it as if it were a local table.