AnsweredAssumed Answered

newbie but used to mysql

Question asked by gsainc on Jan 14, 2009
Latest reply on Jan 14, 2009 by Jens Teich


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