I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field.
My question is, if I publish this data to ArcGIS Server, will an identify operation on that layer return all of the related values in the non-spatial table?
I want to try this, but I don't have sample data that meets these requirements (if anyone knows where I can find some, it would be very helpful).
Here is an example from ESRI of an Identify operation in ArcMap on two tables with a one-to-many relationship. I need to know if the results in ArcGIS Server would be consistant.
I am using ArcGIS 10 and SQL Server 2008 R2.
Best Answer
Regarding your question about identify: no, an identify wouldn't bring back the related records.
But you're in luck since you're using 10. You can now query via relationship classes through REST. You could use a RelationshipQuery to find your related records. Here's a JS API sample showing how this works: Query related records