Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Cascading lookup in CRM 2013 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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