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.