| 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. |