Flagging a parent record
Is there a way to flag a parent record? Let me explain. I have a one to many relationship (Client---<Orders). If ANY of the Orders records contain a certain value in a field, I want the Client record calc field (Clients::cFlagged) to display "Complete." Not the best example but you get the idea. If I simply set Clients::cFlagged= If (Orders::Status = "Complete" ; Complete") I believe the parent record will only reference the last related record; I want it to reference ALL related records.