AnsweredAssumed Answered

If, then, look up

Question asked by MPhillipps on Jul 26, 2014
Latest reply on Jul 26, 2014 by


If, then, look up


     I'm sure that this is a simple thing to achieve but I'm not a programer. I do enjoy developing FM for my company.

     I trying to build a field that "IF" an employee's name is John "THEN" it will look up John rate of $20 and insert $20 in to another another field.

     I have an employee Table with their names and rate. A job Table with actual vers estimated cost/times. I'm developing a total actual labor cost and do not want to use an average employee rate.

     Thank you for your help.