how write Lookup formula RRS feed

  • Question



    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



    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