7 Replies Latest reply on Mar 27, 2017 5:50 AM by mz5005

    Create a table based on unique values in the original table

    mz5005

      I have a large files with customer addresses. Of course many customers live in the same big city. I want to create a city-table based on the unique values in the city field in the original table (for swift data-input of new customer addresses).

       

      Of course I can make a script that generates that table.

       

      But with (cursor on city field)  Insert > From Index, I get exactly what I need. Is there no (relative simple) way to get that index in a table somehow?

       

       

       

      PS Of course I don't really need a city table; they are available everywhere. It's just an easy understandable example to explain my question.