The issue is that there is no inherent relationship between the Job record based on which you want to search/filter, and any Talent record.
But you can add one:
• create a global field
with the same data type as your Job table primary key; say, gCurrentJobIDForSearch.
• create a value list
“using fields”: Job::id (primary key), Job::description (something human readable and unique**), and check “Show values only from second field”.
• create a relationship
from Talent to a new table occurrence of Job, say, Job__forTalentSearch:
Talent::gCurrentJobIDForSearch = Job__forTalentSearch::id
• on your Talent list layout, add a header part
place the gCurrentJobIDForSearch field there and format it as a popup with the new value list.
Since now there exists a relationship, you can place any fields from Job__forTalentSearch on that layout. Use the popup to select the desired Job record; not only can you see its settings, you can change and reference them in scripts etc.).
(Next step: select Talent records, and when you're done, use a script to create records in Job/Talent, based on your selection and the selected JobID.)
You could also use a script to initialize searching for a Job from Job, like
# [ on Job layout ]
Set Field [ Talent::gCurrentJobIDForSearch ; Job::id ]
Go to Layout [ TalentSearch ( Talent ) ]
# [ layout will already show the settings for the Job record you just came from ]
**If necessary, create a calc field, type text, in the Job table like description & " (" & id & ")"
and use that as second field
Thank you SOO Much!! It took me a while to read and comprehend what you were doing with that. But, this worked PERFECTLY!
One other question if I may ask you is.. now that I'm searching for these talents based on some criteria, It automatically fills in the rest of the fields as soon as I do a search. Here's a video of that happening. i.e. I'll search for people that have Bartending skills, but then it automatically fills in Age Range, Status, Body Type, etc. based on the First record.
Here's a video of it happening: Casting