locked
Cascading lookup in CRM 2013 RRS feed

  • Question

  • Hi,

    I have two tables table1,table2 and another table for relation between table1 and table2 is table12_mapping. In mapping table all data mapped to each other.

    eg.

    table1  table2                table12_mapping

    id Name  id Name          table1_id        Table2_id

    1 T1       1  T11                   1                  1

    2 T2       2  T12                   1                   2

    3 T3       3  T13                   1                   3

                 4   T21                   2                  4

                 5  T22                   2                    5

    Now if i select table1's  T1 record then next lookup field will fill with only T11, T12, T13

    Thanks,


    Wednesday, May 7, 2014 8:49 AM

All replies

  • Have a look at this blog post - show how you can create lookup fields that get filtered based on one another

    FILTERED LOOKUP APPROACHES IN CRM 2011


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Wednesday, May 7, 2014 1:06 PM
    Moderator
  • CRM 2013 has the preFilterLookup JS control as well, which can support what you're looking for.  You can find details in the SDK.

    The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

    Wednesday, May 7, 2014 4:18 PM
  • Hi,

    I want to add multiple filter condition(ie. where col1=T11 or col1=T12) in below code:

    var fetchXml =
                  "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" +
                  "<entity name='new_state'>" +
                  "<attribute name='new_stateid' />" +
                  "<attribute name='new_name' />" +
                  "<attribute name='new_countryid' />" +
                  "<order attribute='new_name' descending='false' />" +
                  "<filter type='and'>" +
                  "<condition attribute='new_countryid' operator='eq' value='" + CountryGUID + "' />" +
                  "</filter>" +
                  "</entity>" +

                  "</fetch>";

    Thanks

    Tuesday, May 13, 2014 10:36 AM
  • Hi,

    I want to add multiple filter condition(ie. where col1=T11 or col1=T12) in below code:

    var fetchXml =
                 "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>"+
                 "<entity name='new_state'>" +
                 "<attribute name='new_stateid' />" +
                 "<attribute name='new_name' />" +
                 "<attribute name='new_countryid' />" +
                 "<order attribute='new_name' descending='false' />" +
                 "<filter type='and'>" +
                 "<condition attribute='new_countryid' operator='eq' value='"+ CountryGUID + "' />" +
                 "</filter>" +
                 "</entity>" +

                 "</fetch>";

    Thanks

    Tuesday, May 13, 2014 10:36 AM