Jump to content
Sign in to follow this  

Scripting Multiple finds...

Recommended Posts

...I can do it manually, but how do I script it?

I am trying to find multiple records in one database (A) based on the criteria from multiple records in a second database (B). The common factor between the 2 databases is a number but the common factor between the multiple records in the second database (: is a field that does not exist in the first database (A).

I can manually enter find mode in database A and copy and paste the common number from database B, "Add New Request", and then copy and paste the number from the second record, "Add New Request" again and so on... How do I script the "Add New Request"?

By the way, love the new options! wink.gif" border="0

Share this post

Link to post
Share on other sites

The Add New Request script step is found under the Records heading for available steps, New Record/Request. By using the script step Enter Find Mode (don't forget to uncheck the Restore Find Request and Pause boxes), and then the New Record/Request you would create the desired result. You would also need the Perform Find script step to activate the new criteria.

If you are adding numerous new requests this will have to be done via a loop that start after the Enter Find Mode and ends prior to the Perform Find step.

Hope this helps.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.