Comparing Data In The Same Field In Two Records of Same Table
Is there a method to compare the same field in two different records in a table to end up with a calculated result in both records.
Forum Discussion
So, we run a golf course and use QuickBase for a multitude of different applications, from managing our tee times, to event registration and event scores.
My question pertains to using Quickbase for scoring golf events, and in a typical game it works just fine, sorting lowest to highest breaking ties based on hole scores...
But, in type of event, we have to compare the same hole against the same hole for each hole, thus we were looking for a mechanism to compare field entries between different records in the table.