AnsweredAssumed Answered

Need a value list that removes duplicates from a table

Question asked by ascii7x on Jun 6, 2013
Latest reply on Jun 7, 2013 by billbarman

Good morning all.


I would like to create a valuelist that removes duplicates from the "Products" table.

I created a relationship that searches based on "type".

That works but the problem is that it retrives all records with the same "product name".

Some products are listed multiple times because they come in different sizes.

Some products are listed 20 times.

I would like the value list to only display single product names, not all of them.

How can this be accomplished.