Asked by:
Cascading lookup in CRM 2013

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,
- Edited by yogendrakmishra Wednesday, May 7, 2014 8:49 AM
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- Proposed as answer by JLattimerMVP, Moderator Wednesday, May 7, 2014 1:06 PM
Wednesday, May 7, 2014 1:06 PMModerator -
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