AnsweredAssumed Answered

Help needed with a calculation

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

Title

Help needed with a calculation

Post

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!

Outcomes