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

    FIND with logical AND in same field

    kdjamesrd

      Title

      FIND with logical AND in same field

      Post

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

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

      Example

      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. :)