AnsweredAssumed Answered

Script for Performing a Find in One Table Based on Data in Linked Field in Another Table

Question asked by SBAndrew on Apr 23, 2009
Latest reply on Apr 23, 2009 by philmodjunk

Title

Script for Performing a Find in One Table Based on Data in Linked Field in Another Table

Post

Hello:

 

I cannot seem to figure out the scripting for this (I'm new at this).  Here is the problem:

 

1. Run a script to pick up field value in open table (field is agreement number) (which is a text field because some are alpha numeric).

2. Change to a related table and run a find on that value in a linked field also called agreement number.

 

In other words, I'm looking at a client information table (with agreement number) and I want to switch to invoice table and display those invoices with that agreement number.

 

Thanks for any help. 

Outcomes