Adding a button for a specific action

:)
OK, the reason that I kept after you on that issue was there is an easy way to roll up the maximum of a numeric field but I don't even think there is a way to roll up the maximum of a text failed. So the answer was either it was going to be impossible or very easy.  


So there are a couple of things to do. The first is to set up a formula numeric field called perhaps ZIP Code numeric. 

ToNumber([Zip Code])

Then you need to create a helper table with only one record in it. Call the table maximum ZIP Code.  Add one record to it and then lockdown permission so that nobody even the admin can add or delete any records.  

The only record in this table will have Record ID = 1.

Create a new field in your details table called [Linked to Maximum ZIP Code]

Set he formula to be
1


Then simply make a relationship where one maximum ZIP Code record has many detail records and use that formula field to connect the tables. Add a summary field to summarize the maximum of the numeric ZIP Code. And then look up that maximum ZIP Code down to the details table in the relationship. Now all detail records automatically know the maximum ZIP Code record. 



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------