locked
how write Lookup formula RRS feed

  • Question

  •  

    hi,

    i need to update the feilds with recpect to some fields for example

     

    where id="2" and firstname="abc" or firstname="bcd"

     

    like that i need to write in lookup formula editor how i need to write the formula.

    please guide me

    Thursday, November 29, 2007 7:36 AM

Answers

  •  

    If I understand correctly, you wish to use some query logic to filter what is displayed in a lookup field on your form.

     

    Ronald Lemmen has a post on just this very thing - http://ronaldlemmen.blogspot.com/2006/12/filter-data-in-crm-lookup-field.html

     

    Basically you create a FetchXML statement and inject this into the lookup control using JavaScript. I use this method and build the FetchXML "on-the-fly" so that the lookup results are aware of values that were selected in other fields on my form. This sounds like it might be a good fit for what you need.

     

     

    Thursday, November 29, 2007 9:16 AM