Trying to insert text from a calculation field if has ever occured
If a person fails to attend an even he is scheduled for and has ever failed in the past to attend, I am trying to insert the text "suspended" into a different field. Each attendance or fail to attend is noted in a different record.
I don't know how to (or if possilbe) evaluate in a calculation if the person has ever failed to attend from another record so I can mark/identify the person as "suspended" from being registered.
Relationships can be used to produce this result, but we'd need to know the current tables and relationships you have in place before we can suggest what combination of new table occurrences and relationships might serve to do this for you.
And there might be ways to accomplish this using a calculation field or via a script.