AnsweredAssumed Answered

newbie but used to mysql

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

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

Outcomes