I've done some searching through the forum and have come up empty.
I have a field setup that is setup with a drop down value list. The value list is based off of records in another table.
Would it be possible for the value list to omit the current item selected?
For example, lets say i have a field called "Letter" tied to a value list containing the alphabet. If the Letter field value is currently C, if i click the drop down list is there any way to make C not an option to select? To take it a step further, is there a way for it to not be an option on other records as well?