AnsweredAssumed Answered

Flagging a parent record

Question asked by EP on Apr 4, 2013
Latest reply on Apr 5, 2013 by philmodjunk

Title

Flagging a parent record

Post

     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.

     Thanks

Outcomes