Forum Discussion

Qrew Cadet

3 years ago

Formula field that is unique to each record in a table

Is there a way to have a formula field be unique to and have different values for, each record? Each of the 40 records in our Locations table has fields that describe the location and these are unique...

Formulas and functions

DonLarson

Qrew Elite

3 years ago

Brian,

In the long run a table of Tanks is going to serve you best. I suspect there are other unique things about them

Serial Numbers
Government Inspection Dates
Foundation Material
Single Wall/ Double Wall
Hazard Ratings

and so on.

Having a formula in the table that calculates volume from its unique geometry is just one more part of tracking these for the long term.

------------------------------
Don Larson
------------------------------