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!