English

Problem: Querying a spatial view in ArcGIS Desktop returns inconsistent results

Description

Selecting or displaying records in ArcMap or ArcCatalog from a spatial view with one-to-many cardinality returns inconsistent results.

Operations like Identify may only return the first related record, rather than all related records.

Cause

ArcGIS Desktop requires ObjectID values be unique per record. If a spatial view joins one record in the feature class to several records in another table (a one-to-many join), the ObjectID values are no longer unique per record. This is not supported in ArcGIS Desktop.

Solution or Workaround

Use a relationship class or a RELATE function to join the feature class with the associated attribute table in ArcGIS Desktop.