Return to FileMaker.com
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")
Retrieving data ...