Script for Performing a Find in One Table Based on Data in Linked Field in Another Table
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.