AnsweredAssumed Answered

Status conundrum ...

Question asked by Matty_1 on Jul 12, 2013
Latest reply on Jul 12, 2013 by Matty_1


Status conundrum ...


     I have a one to many relationship between two tables, DispatchCentral (one) to DispatchJobs (many).  I'm looking to create a calculationfield that verifies all the status fields in DispatchJobs from the stand point of DispatchCentral.  If they are ALL empty I want the status to say "In Progress", if one to one short of all records have data in them I want to see "Partially Complete" and finally if all status fields have data I want to see "Complete"

     Is there a function can look across all it's related records instead of only the first?