CRM 4.0 - Add columns from related entities in associated view RRS feed

  • Question

  • Hi,

    I am using CRM 4.0. I want to add related entity's columns in Associated view for one of the entity. It's not possible in CRM 4.0 but possible in CRM 2011. Is there any workaround/approach to make it possible in CRM 4.0?

    Monday, September 30, 2013 11:28 AM

All replies

  • View is just like the real table that contains the field more than from one  table.and use the below mentioned sql command:

    create View [MyView] as


    select col1, col2, col3 from Table1


    select col1, col2,col3 From Table2


    Monday, September 30, 2013 12:36 PM
  • You can add the column of related parent entity in views of crm 4.0. Same is true fro CRM 2011.

    Regards Faisal

    Monday, September 30, 2013 12:43 PM
  • Thanks for reply Faisal. I can add columns of related entities in views but not in associated views in CRM 4.0.
    Tuesday, October 1, 2013 5:06 AM