ArcMap requires selection of unique identifier fields

[gregbunce]

The problem

ArcMap shows a pop-up requesting the user to select unique identifier fields.

The reason

When ArcMap creates a query layer from an Open SGID table, it does not automatically choose xid as the primary key or unique identifier field.

The workaround

Select xid and click Finish. The xid field is the name of the primary key when we load the data into the Open SGID.

To avoid repeating the steps above, use the Save As Layer File to store the unique identifier and layer extent.

Examples