Rebuild an index?

[jackinva]

I've written several AppleScripts that work with Filemaker databases. The scripts usually involve searching database files for records and if not found will insert records into multiple tables.

I've noticed that sometimes, I have to perform a search manually in FileMaker and then select show all to get my script to work properly. Otherwise the script search seems to find a match to the first record in the database.

I'm guessing that somehow when I manually perform the search, that Filemaker refreshes the index on the [primary key] search field.

Is there a way that I can have AppleScript tell FileMaker to re-index fields? I'm thinking this would make sure that the search that would follow it would always work accurately.

Thanks,

Jack