Case or If or some other function, maybe?
Hello, I'm a new FM user and trying to build a database for archaeology.
We dig pits that have four corners, southwest, northwest, southeast, northeast.
Every so often we measure the depth of each pit (e.g., in the southwest corner we started at 386.60 meters above sea level and dug 40 cm below (=386.20 m), in the northwest corner we are 38 cm below, etc.).
We take this measurement using ONLY ONE CORNER (the "reference corner") but it varies by pit (so in Pit 1, we used the southwest corner, but in Pit 2 we used the southeast corner). Thus to know the depth of each corner, we subtract our measurement, say 35 cm, from the "reference corner".
I created an option that lets the user select, via radio button, which corner was used for measuring. Great.
Now, I would like automate the subtraction process. When the southwest radio button is clicked, I want to subtract the specific depths from all the corners, only from the southwest corner value. When the southeast radio button is clicked, I want to subtract the specific depths from all the corners, only from the southeast corner value, etc.
Here's a screen shot of the portal:
It's in Spanish:
"cm below reference corner"
"final elevation of level"
Ideas..help.. ?? Thanks!
Also, these are what the numbers SHOULD be, but I had to do it myself on a calculator. I'll have about 600 records, so I'd rather not have to do it all manually...