AnsweredAssumed Answered

Calculation Question

Question asked by SFX on Sep 2, 2010
Latest reply on Sep 2, 2010 by SFX


Calculation Question


Hello everyone, I'm kind of new to the FileMaker DB, and I have a question, first this is what I have:

Tables: Table1, Table2

Fields: Table1::ID; Table1::Field1; Table2::id; Table2::Field1

Relationship between both tables using the id field on both, Table2::Field1 has a list of values (a,b,c)

What i want to do is put in the Table1::Field1, the number of fields that match with the ID and Table2::Field1 = a

I tried different things with Sum, Count, Get but nothing is working properly, such as:

Sum ( Table2::id = Table1::ID; Table2::Field1 ="a")

But if there's any other record with the same id but with value b, it puts 1 and if I change any value it only displays 2 an do nothing more.

I will greatly appreciate your help