I have a table [Samples] and every Sample has a calculated field Sample Status. There is also a field called Location and another field called Exception.
If Location = null and Exception = "Not Used" then the Sample Status = "Late".
Once the Sample is given a Location the Sample Status changes to a new status and I can no longer track which samples where late. Is there a way to create an attribute that would flag a Sample if it ever has a Sample Status = "Late" that I can reference this info even after the Sample Status is no longer late?