I have a table, called ‘Industry,’ with 2 columns of Industry type codes. The first column has many repeat values in it, the second column are unique values, for example:
Manufacturing Textile Mills
Manufacturing Apparel Manufacturing
Manufactu...
Thanks. At least the answer is unambiguous and I understand how I could implement the suggested workaround. I’ll have to decide if it’s worthwhile for this particular instance but it’s a good approach that I may have use for in the future as well.