Create Table from Unique Values in Other Table

[Michael_Houck]

Hi! A bit surprised I haven’t been able to find an answer for this, or figure it out myself.

I have a table that has duplicate values in one column. I want to return all unique values from that column into a new column in a different table within the same base. Ideally, I’d like the column in the new table to be the Name column.

How can I do this?

Thanks!

[Kamille_Parks]

Turn the column with duplicate values into a LinkToAnotherRecord type field, ‘point’ it at a new table.