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


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.


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.