Is there one "contact" record to linked to any given artwork in the artist's inventory or might multiple contacts be linked to the same item in the artist's inventory?
Assuming only one collector to a given artwork in the artist's inventory, then each Collector should have one record for that collector in your table of contacts.
Collectors::__pkContactID = Inventory::_fkContactID
The simplest option for selecting a collector's contact record for any given Inventory record is to set up Inventory::_fkContactID as a drop down list or pop up menu of Contact ID numbers (field 1) and Contact names (field 2).
I have something similar and Ive used Set Variable[$$TriggersOff; Value 1]
Set Variable [$Item;Value:Transactions::ItemID] <--The Item ID is the name of the item or in your case it would be the contact.
So maybe use this and then I used Go to layout where the information was ["Transactions" (Transactions)]
Enter Find Mode
perform find [restore]