filered value list/ filtered table occurance
I am trying to limit a drop down list in the following set up.
TO=Action related to a join table of IDs which link to several other TOs of Jobs, Names, Companies.
New Action Layout has portals to the others. I know how to set up the lists, and show the resutling choices.
What I want to do is limit the list, for example to Jobs that are open or companies in the us. I found the concept of creating a calculation field such as [if job status= open or job status=hold;1;0]. I am failing at the next step which is how to create the value list limited to x=1.
Apologies if this has been covered many times, i found a couple of possible answers but lost track of the concept in the particular details and couldn't replicate. thanks all as always.