Source Tab with Table allow duplicates

[KenStuder]

When adding a reference to a Table in a map document, you can not have the object represented more than once.  If you apply a definition query to filter the table, you then can not add the same table yet have a different query applied.  Also, although you can sort the values in a particular column, we do not have the ability to report the distincts and the count of the distincts either.  This functionality is available in a layer file and would be useful on the table side as well.

[ChrisFox]

Thank you for your idea. In regards to the second aspect of this request I believe if you right-click the field you wish to report the distinct records and select summarize you will produce a table of distince records with a count of how many times each occurs in the table. Please comment back if this was not the functionality you were looking for.

[PaulLohr]

Hi Ken,

This is an old post but perhaps this will be helpful. This is aimed at the idea of having multiple copies of a table in the same map document. If you run the Make Table View tool from within a modelbuilder session and choose 'Add to display', a table view should be added to the table of contents. The table remains in the map document even after saving / closing / re-opening. I tested this with version 10.2.2, ArcSDE and SQL Server 2008 R2.

Merry Christmas,

Paul Lohr