AnsweredAssumed Answered

Create a table based on unique values in the original table

Question asked by mz5005 on Mar 24, 2017
Latest reply on Mar 27, 2017 by 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.

Outcomes