Automating Finds

[Aaron_I]

I'm trying to create a script that automates finds by copying a specific field in one database, enters the find mode in the 2nd database, pastes into the field I indicate, and performs the find.

I have tried setting the field instead of copy and paste, but I can't seem to do either when I'm in the find mode.

[BobWeaver]

When you are in find mode, you don't have a current record, so Set Field doesn't know which record to get values from unless the calculation is based only on global values which don't depend on a particular record. What you can do is create a bunch of global fields for data transfer . Go to browse mode and use set Field to set the globals to the fields you want to get. Then go to Find mode and use set Field based on the globals.