AnsweredAssumed Answered

Calculation Help

Question asked by Annette on Oct 15, 2012
Latest reply on Oct 15, 2012 by philmodjunk


Calculation Help



     I have a table called "People".  on that table I have a field called TypeofPersonFlag which is a checkbox set with a value list I created.  All well there. 

     I have another field which I have called GPFullName for example; and I am trying to calculate that if  "GP" is marked in the TypeofPersonFlag checkbox that it gives the last name, full name of that person.  I thought it was simply :

     If( TypeofPersonFlag=GP; LName  &  ","  &   " "  &  FName; "")

     But I get an error message saying the specified field cannot be found and it highlights GP. 

     This is probably something really simple that I'm missing but as I'm new to trying to figure out calculations and filemaker in general i'm not sure what I'm doing wrong. 

     Thannks in advance for the help.