Ability to label features with information from both 1:1 and 1:M related tables

Idea created by RudinA on Jun 6, 2012
    Duplicate
    Score0

    This idea has been merged with Support labeling on related fields.

    I would like to be able to display information about features that is stored in related tables.  Sure I can do a join if the relationship is 1:1, but if it is 1:M that is not an option, since only one record will join.

    If there are 3 values in a related table that I want to display on top of a featue, I'd probably want them shown as a comma separated list, or with 3 seperate lines of text.

    We use relationship classes alot, so I'd like to tap into these to display more information to my users.  I've heard there are ways to build VBA/Python logic into the label engine to do some sort of query on the related table and return a string of the multiple values, but I havent seen sample code for this, and it seems it should be easier, or ESRI should have a sample available via the help.

    Thank you