Hi, I have multiple people entering information into docs and then I have a view that shows all the values for a field. If 2 people entered the same value for the field how can I make so that the view only shows 1 of them instead of both.
Thanks
Jacob
Subject: views
i think you need the @unique formular if this is a multivalue field …
Subject: RE: views
What about if it’s 2 different documents w/ the same field.
Subject: RE: views
ok. then i think you need categories like this
field value (in doc 1 + doc 2) ← categorize this column
another field value of doc 1
another field value of doc 2
Subject: views
It’s not clear exactly what you want, but maybe you could:display the possibly duplicated value in a categorized column, or
Use the view option “For ODBC Access: Generate unique keys in index.” (note: this may not work with some datatypes, and I believe it considers all sorted columns part of “the key”).