Show Relationships of more than 2 jumps in Data Grid

Hi I have a normalised database in which I have a M:M relationship between contacts. The main objects are Contact, Relationship and Type A Contact has a Type (and a sub type). A type can be Client or Sales or Service. A Client is supported by other Clients (Sales / Service) The Relationship object therefore creates 2 records for the Client Client - Sales Client - Service And similarly there are multiple Sales records and multiple Service records. I am having difficulty getting the role name (Type) to display on a grid and am getting an error "A column of a data grid that has an association source can only show attributes of the grid entity itself, and attributes of directly associated entities" Is there an alternative way to get this data to show in an associated grid?
0 answers