view distinct values from a field?

view distinct values from a field?

I want to create view that displays the unique (SQL: distinct) values from a text field? how? 
once I get the unique values from the view, how can I use this data to populate a new form(table)?