6 thoughts on “Filtered Lookup in MS CRM 4.0”

1. Thabiso Motloung July 22, 2010 at 3:00 pm

   Hello all,

   I have a productid lookup in the qoutedetails entity which looks up the product table entity which is a custom entity.

   And again I have a new_professionalsid which holds the names of all the name of all the Professionals in my table.

   I want when I select the Product from the productid entity for it to display the the Product eg) Electrical Engineer.

   The new_professionalsid should lookup a the Product that was chosen and create a filter based on the productid and only bring the names of the indivisuals whose Profession is Electrical Engineer.

   The code:

   OnChange() /* Which I placed in the productid onchange field.*/

   FilterLookup(crmForm.all.productid, crmForm.all.new_professionalsid);

   OnLoad() /* Is placed on the onlad form of the qoutedetail entity */

   FilterLookup = function(source, target)
   {
   if (IsNull(source) || IsNull(target)) { return; }

   var name = IsNull(source.DataValue) ? ” :
   source.DataValue[0].name;

   I dont know where I’m going wrong with my coding please assist

   target.additionalparams = ‘search=’ + name;

   Reply ↓
   1. mahenderpal Post authorJuly 23, 2010 at 6:51 am

      Have you added find column in new_professionals lookup window ??

      Reply ↓

2. Pingback: 2010 in review « Mahender Pal

3. Catalina November 5, 2012 at 10:14 pm

   I think the admin of this web page is truly working hard
   for his website, because here every data is quality based information.

   Reply ↓
4. cialis online February 22, 2013 at 3:35 pm

   Do you mind if I quote a couple of your articles as long as I
   provide credit and sources back to your site?
   My blog site is in the very same niche as
   yours and my users would truly benefit from some of the information you provide here.
   Please let me know if this okay with you. Many thanks!

   Reply ↓
   1. mahenderpal Post authorFebruary 27, 2013 at 5:22 am

      Sure

      Reply ↓