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.