5 Replies Latest reply on May 21, 2012 9:01 AM by philmodjunk

    FIND with logical AND in same field



      FIND with logical AND in same field


      Trying to perform a Find using a logical AND in the same field.

      Have records that contain many variations of "yogurt" and "blueberry":


      1. low fat yogurt

      2. blueberry yogurt, low fat

      3. raspberry yogurt, low fat

      4. blueberry muffins

      5. blueberry pancakes

      6. non-fat blueberry yogurt


      Goal: Obtain a found set that contains

      1, blueberry yogurt, low fat

      2. non-fat blueberry yogurt


      My attempted procedure.

      Step 1. Find "yogurt" (which shows all records containing the word "yogurt")

      Step 2. Use this Found set for another find "blueberry" (which shows all yogurt records that contains the word "blueberry")

      Question:  How do I use a Found Set as the basis for the next Find operation?   (I am still new at this, coming from MS Visual Studio and Lightswitch).

      Thanks for any advice. :)