Are probably many ways to do this but one way would be to trigger an automation when an address is added or edited and the primary checkboxes checked.
I would set up a checkbox field which would be true of the [Date Modified] was not within the last minute.
The field might be called [Previous Primaries OK to clear?]
IF(Now() - [Date Modified] > Minutes (1) and [Primary] = true)
The automation would modify other records which were primary but had not been just modified.
Make sure that the Automation filter just applies were the Related Parent is the same as the record being modified.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
