Forum Discussion

ScottPugh's avatar
ScottPugh
Qrew Cadet
7 years ago

Setting a 'Primary' address- How to ensure only 1 child record has a checkbox checked

I have a location table with a relationship to an Address table.   Each location can have many addresses.  I'd like to add a checkbox to the address table called 'Primary'.  The purpose of this field ...
Forms
Formulas and functions
Tables and fields
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
7 years ago
Since you have a direct relationship between Locations and addresses - the easiest way is to summarize the # of Addresses records where that box is checked into your location table through regular summary fields. Then - do a lookup of that field back into your address table. With that new counter - you can set up form rules or automations to uncheck any addresses that get flagged once you already have a primary address checked off.



Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base