Perform Dynamic Query on PopUp List Selection
I have a table that includes a field called Connector ID. For each Connecter ID there is a related Contact ID, for each Contact ID, there is related data. The same Connector ID may have several Contact ID fields. So to try to explain, my table would look like this:
Connector ID Contact ID Available Stock Contact Price
AABBC 11223 25 $.25
AABBC 11224 50 $.35
AABBC 11225 30 $.15
AABBC 11226 22 $.05
AABBC 11227 10 $.55
I'm performing a Script in Layout A that triggers the following script from a PopUp Menu:
Enter Find Mode [Pause]
Set Field [Connector Specs::Connector Selector]
Set Error Capture [On]
Perform Find 
Set Error Capture [Off[
In this script Connector Selector is a Global field that contains a PopUp Menu of data found in Connector ID. Upon execution of this script, there is a second script that takes the user to Layout B where data related to the selected Connector can be found, to include a picture and other related data.
Here is my issue (finally) how can I get all related Contact ID data to appear in the new Layout? Is this something that I would use a Portal for, and if yes, how would it work?
In short, if in the field Connector Selector the user selects Connector AABBC, I need all related Contacts (11223, 11224, 11225, 11226, 11227) and related data to appear. The related data is Available Stock and Contact Price of each contact to appear in the new layout.
To further complicate the issue, some Connectors my have 20 related contacts, others may only have 5. I would like to have a table that is dynamically built based upon the number of available options to keep it cleaner.
I know this is an incredibly long post, but I would appreciate any help anybody can offer.