I was wondering if anyone knew of any workarounds or developer tools for building labels and symbology off of fields in a 1:M relationship? I deal with data wherein one area frequently plays host to multiple programs, which I need to label / symbolize appropriately. Barring the tedium of manual labeling and symbolizing, I can't find any way to reflect 1:M relationships in ArcGIS 10.
I know this has been something of an ongoing problem with ArcGIS and was wondering if anyone had seen or developed workarounds for 10. There are some developer tools for older versions of ArcGIS but none that I've tried have worked with Arc 10.
If anyone could help with this I'd be incredibly appreciative, I deal with related datasets all the time and at present am stuck doing a lot of cartographic work by hand.