function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sean_at_33050sean_at_33050 

lookup list shows only items not chosen yet?

Is this possible?
Say you have a custom tab: objects called: lots with lot_01, lot_02, etc. (Each lot object has a custom checkbox field: In_Use.) You have a custom field (lookup) in opportunities called "Space:"
Let's say you goto Oppurtunity "X" and lookup and choose "lot_01" for field "Space". Now I want to goto Oppurtunity "Y" and populate the field "Space" using the lookup feature. Since lot_01 has been used in Opportunity "X", when I select the lookup for field, I do not want "lot_01" to be a choice. Once the field "Space" on Opportunity "X" is blanked out, then lot_01 appears within the lookup list again.
(Users can be trusted to not enter junk manually into the field) 
I don't have to use Lookup list - I can go with a picklist - I just need to draw from a pool of items while preventing the same list item from existing in more than one Opportunity.
Is this possible? 
 
Thanks.
sean_at_33050sean_at_33050

Bump.

Any ideas???

This is a trivial matter in mysql/php. How about SalesForce?