Filtering multiple custom CRM Lookup

Let me explain the scenario.. We have a Model lookup and a variant Lookup on Lead form. Every variant is associated with a particular model. i.e One model have multiple Variant. Eg. Model          Varient Alto             Alto LX Alto             Alto Xcite Alto             Alto LXI SX4               SX4 VXI SX4               SX4 ZXI Leather SX4               SX4 ZXI —————————- Now [...]

Using the Advanced Find for FetchXML builder

You can just open the Advanced find page and build the query as you like. Then run the query to see if it returns the data as you wish it should. If you are satisfied with the results and you want to know what query was sent into the CRM Framework, then press F11 to [...]