10 Replies Latest reply on Jul 27, 2015 8:35 AM by EdwinMerced

    Variable Report based on Rating



      Variable Report based on Rating


      I have a table with the following fields: FruitName, Fruit Description, FruitRate (lookup value of 1-4)

      I have another table with the fields: Store, Manager, Location, FruitRate (1-4).

      I need to reate a printed report for each Store where for each store there is a fruit rating. If the fruit rating is 4 or 3 the FruitName and Fruit Description will appear on the report, otherwise (FruitRate is 1 or 2) no text will appear in the report. 

      This will include infinite stores but a limited amount of FruitNames (93 exactly). So each store will rate each of the 93 fruits.

      Can I get some suggestions on how to best accomplish this in Filemaker?

      Thank you