I have the following tables:
Users < Machines
A field in the machine record is manually checked when a machine is getting replaced.
I want a User field to show a check if one of their machines is getting replaced.
The solution I thought of is to create two fields in the User's table:
- summary field that totals # of machines checked for replacement
- a formula checkbox that is checked of the above summary field has a value greater than one
Or is there a simpler solution?