First occurence search
In filmmaking there are several situations in which you pull several shots from one roll of negative.
But when you have all the shots you want to pull in a list--is there a way to then display only the first occurance of each roll of negative?
So it's not really the same as a "find unique values in a field" which you can do with an inversion of the "!" search (but will exclude the records for which there was only one original value). What it really is is a "please show me the first use of a specific value" search, eliminating all subsequent uses of that same value.
Am I being clear?