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.