How to display records in a Sub-Grid related to a lookup field value on the record

Vraag How to display records in a Sub-Grid related to a lookup field value on the record

  • zaterdag 28 april 2012 1:46
     
     

    How to display records in a Sub-Grid related to a lookup field value on the record

    Eg: In CONTACT entity we have customlookup(new_region) and a subgrid(new_country)

    On change of lookup(new_region) need to display related records in the subgrid(new_country)

    Thanks,
    Madhu M.

Alle reacties

  • zaterdag 28 april 2012 4:55
    Moderator
     
     

    Hi,

    you can easily do this, let's say, I want to add subgrid for contacts in account, only contact related to that account should be visible there

    so while adding subgrid you need to set datasource accordinlgy like below, so now only related contact will be visible in accounts, the same you can do with your custom entities


    Mahain : Check My Blog
    Follow me on Twitter
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    • Als antwoord voorgesteld door Mahender PalMVP, Moderator zaterdag 28 april 2012 4:55
    • Voorstel als antwoord ongedaan gemaakt door Madhu_M zaterdag 28 april 2012 5:07
    •  
  • zaterdag 28 april 2012 5:06
     
     

    Contacts related to the parent entity can be displayed.

    But our requirement is little different, we need to show contacts related to another child entity which is part of parent entity.

    Example:

    Account is Parent entity, where new_region(lookup) and new_country(Subgrid) are child entities of Account entity.

    based on the new_region(lookup) value need to show the related records in the subgird new_country.

    Thanks for responding. 

    Any response on this would be much appreicated


    Madhu M.

  • zaterdag 28 april 2012 5:18
    Moderator
     
     

    In that case you can create a custom filtered view and target it to subgrid.

    you can refer : http://javascripterrors.blogspot.in/2011/07/crm-2011-add-custom-view-to-subgrid.html


    Mahain : Check My Blog
    Follow me on Twitter
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.