There are two ways to do this.
One way is to completely drive the Status of the Customers off a formula field rather than a multiple choice field. You would make a few summary fields to count the total number of Assets and the number of Inactive Assets and then make a formula to calculate the status.
But if there is more to it than just that and you still need manual entry on the Customer for the Status then yes,
You can use an Automation to do this.
You will need to have summary fields on the Customer which are in turn looked up back down to the Assets records for the [# of Assets] and the [# of Inactive Assets].
Then you would create a Automation.
The trigger would be when a status changes on an asset, and there would be conditions that the
[# of Assets] > 0
and
[# of Assets] is equal to [# of Inactive Assets]
The action would be to edit record in the Customers table, filtered by where the [Record ID#] = [Related Customer] of the trigger record. be sure you have the filter or it will update all customers :(. But I think, in fact it forces a filter to prevent that mistake.
Then the Action will to change the status of the Customer to Inactive.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
