Hi @chris19,
I recommend you just use an option set for your Address Status choices. It’ll make this much easier for you. And then in your Address data type, replace the current Status field for a new one whose type equals the option set version.
When you do this search, you’ll be able to add a constraint that looks like Status = Current.
Right now, you’d need to set that constraint value to another Search (of Statuses) and constraint the search, go to the first item, etc. This is a perfect use case for the relatively new option set feature.
Take a look at this for more info: [New Feature] Option sets
Cheers,
Gaby
Coaching No Code Apps
Join our Facebook group for insider access to no-code development
Get professional development services
Enroll in expert-led courses and products