2 of 2 people found this helpful
What I want to do is only show the "Available" LISTING in the ENQUIRYJOIN layout when a LEAD enquires about the new listing.
Since you don't want the user to select a "filter" value for the conditional value list, but only and always want "available" listings, this is what I call a "hardwired" conditional value list. A relationship can be used for this or a calculation field defined in the listing table can be used.
See the "hardwired conditional value list" examples found in this teaching file:
In the resources section at the end, you'll also find a download link for a file that demonstrates more advanced methods that can be set up for selecting values from a list.
(please check out the "geek busking" info on the introduction layout.)
Thanks Phil, you're a genius.
That was so simple once I had the example in front of me. In the end I used the calculation field only hardwired option.
Yes, I like that method too. For one thing, you can use a value list based on that calculation field on any layout in your file where the typical relationship based hardwired conditional value list only works from the context of a single table occurrence--which can force a developer to create multiple copies of the same CVL, but with different table occurrence references.