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

    newbie but used to mysql

    gsainc

      Title

      newbie but used to mysql

      Post

      Hi

       

      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")