I sent you a private message.
Thanks, I appreciate your response.
However, I feel that my task is very simple (or at least, it should be). I've taken a screenshot of an example page I've made in hopes of providing a visual cue as to what I need:
I would like it so that when viewing our Jobs List (the spreadsheet page in the background), I can simply click the Job Name (Airport Atrium) and have it bring me to the Contact Management page in the foreground, where I can easily access the customer's information.
What would be the most simple way to do this? Am I trying to do something that's not even possible?
This is pretty easy to do, but some details will differ depending on whether you have two files here or one file with both tables.
Here's a sample script for two tables in the same file: (substitute your actual table and field names for mine).
If [not isempty(Projects::ContactID)]
Set variable[$ContactID ; Value: Projects::ContactID]
Go To layout [Contacts]
Enter Find Mode
Set Field [Contacts::ContactID; $ContactID]
To make it work on two files requires passing the contactID data (you have to have a field in projects that uniquely identifies a record in contacts.) as a parameter to a script that performs the find in the contacts file instead of using a variable, but otherwise it's the same.