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?