AnsweredAssumed Answered

Help needed with a calculation

Question asked by cmcbain on Nov 4, 2009
Latest reply on Nov 4, 2009 by mrvodka


Help needed with a calculation


Hi. I'm very new to filemaker and need help making a calculation.

I have to fields (which are drop down text boxes). I want a third field to effectively "add" these together for an automated response.

My text fields are:

Field 1: Single Adult, Double Adult, Single Parent and Family

Field 2: Single Adult, Single Child, Adult + Child, Child + Child, N/A


and ideally I want the calculation to be able to give these responses:


Field 1               Field 2               Field 3 (calculation)

Single Adult        Single Adult        = Double Adult

Single Adult        Single Child        = Single Parent


and so forth.


Can anyone help me make this work?

Thanks very much!