1 Reply Latest reply on Jan 14, 2009 1:52 PM by Jens Teich

    newbie but used to mysql



      newbie but used to mysql




      I am a noob in filemaker. What I need to do is get data out of my DB in a way like I can with MySQL : select * where "field" = "x"


      Perhaps that is not a good example but basically I need to SUM("values") for all records where a "chosen_field"="chosen_field(of current record)"


      in MySQL I could SELECT all "values" WHERE "chosen_field"="chosen_field(of current record)"

      - then set a variable array and add all these together giving me SUM("values")