Can anyone help me figure out what I'm doing wrong?
I am the administrator (scary)
File A is accessed from a server
File B is local on my laptop
They are related by File A's primary key
I would like to automate the search for information from File A using the Quick Find for that information in File B. If the search finds records, then a field in File B will be set with File A's key. Essentially, I'm trying to create the linkage in a one-to-many relationship between Files A and B based upon the scripted search. Using the Quick Find is important because File B is a compilation of information from multiple resources which do not always conform to specific fields.
This search involves three local variables created from File A - $searchString $state $key
$searchString is the information used in the Quick Find done in File B
$state - I need to constrain the found results to a particular state
$key is File A's primary key which will replace the contents of File B's field linking the two databases
My initial problem is that the search, which takes 1 second when done manually, ends up taking forever - I've canceled after waiting several minutes without getting search results.
Below are the script steps I have so far (it presently assumes the File A window is open-active and File B's window is open-inactive)
Set Variable [ $key ; Value: FileA::key ]
Set Variable [ $searchString ; Value: FileA::info ]
Select Window [ Name: "FileB Search" ]
Perform Quick Find [ $searchString ]
Constrain Found Set [Restore]
Set Field [ FileB::fKey ; $key ]
Thanks for any help or suggestions!