symbology - Symbolising One-to-many relationships using ArcGIS Desktop?

I have a polygon feature class which has various extent areas with a name which is unique

I also have a table (in a file geodatabase) that has the extent names with a score value. But there can be many score values per extent.

I want to visually represent the score values either by colour symbology or pie/bar chart symbology in ArcGIS Desktop (I have an ArcInfo license too).

It's one of these questions that get bounced round the Esri forums quite a bit, so I was wondering if anyone here had any suggestions or any work arounds that they have done in the past?

Answer

For a programmatic approach, I see several options:

With any of these approaches, you can use IRelationshipClass.GetObjectsRelatedtoObject, (or RelatedToObjectSet), assuming you've set up a relate to the score table.