AnsweredAssumed Answered

Parent calculation field to find current job position

Question asked by jgritt01 on Mar 28, 2013
Latest reply on Apr 1, 2013 by jgritt01

I have a parent table of People and a child of Job Positions the person has held over the years. I want a calculation in my parent table that will return the person's current job position -- i.e., the one without an end date from the child table. I have tried everything I can think of and it's not working. Tables are linked with a People UI. I tried Case function saying that if the end date was blank, return job position, and if the person has held one position it works, but if multiples, is blank. Example is for jobs, but need it for other parent/tables like telephone #'s and addresses - basically want the calculation to return field contents in a record based on the value of another field in the record. Any insight would be greatly appreciated. Thanks

Jamie Rittenhouse

University of Louisville