AnsweredAssumed Answered

Creating a unique values table

Question asked by BCSG on Aug 18, 2011
Latest reply on Aug 19, 2011 by BCSG


Creating a unique values table


I have a 'transaction' table that includes many instances of the 'product names' being sold.  I want to create a table that has the unique product names from the transaction table, that I can add as a lookup table in the relationship scheme. 

How to generate a subset of unique values from one field in a table that I can place in another table.  Thanks in advance, Bill