Customer Service | Training | Contact Us
You are here: Home > User Forums > arcgis server forums > Thread Replies

ArcGIS Server Forums

ArcGIS API for Flex forum

Map service that supports one to many joins...   Susan Mordy Nov 06, 2009
Report Inappropriate Content • Top • Print • Reply    
Subject Map service that supports one to many joins? 
Author Susan Mordy 
Date Nov 06, 2009 
Message How is everyone dealing with not be able to create a map service that supports one to many joins?

Just wondering if anyone has created a work around solution as I can't be the only person with spatial data that requires a one to many relationship to display all of it's attributes.

For example, say I have a point feature class. At each point location there can be more than one service. For example, at Point 'A' there is a library, a gym, and a community centre.

I want the user of my Flex application to be able to know what services are available at a single location, using the identify tool, mouseover or query builder results table.

Either I could have 3 separate point feature classes (which doesn't make alot of sense and wouldn't be very user friendly), or have one point feature class that links to a table.

I realize ArcMap joins don't produce one to many relationships and a MSD doesn't recognize relates.

This seems to be a reasonable thing to want to do, but I am stumped as to how to make such a simple thing happen using the Flex API.