Using a script to find related records...'
Good afternoon Forum,
I have client records in a contact table who have quotations in a quotation table. They are linked by a customer ID #.
When I am viewing a particular client in the contact table, I'd like to run a script that will go to the quotes layout, enter the contact ID # and pull up all the quotes associated with that client. Here's what I have so far:
Set Variable [$k_ID_Contact; Value:Contact Management::k_ID_Contact]
Go To Layout ["Quotes" (Quotes)]
Enter Find Mode [Restore; Pause]
<Action = Find Records......Criteria = Quotes::Customer ID: [$k_ID_Contact]>
Perform Find 
What results is that the Customer ID field shows the characters '$k_ID_Contact' and and error message appears reading "no records match this set of find requests"
Can anyone see what I'm doing wrong?