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