AnsweredAssumed Answered

Comparing numbers and associated labels

Question asked by mattd on Dec 14, 2009
Latest reply on Dec 14, 2009 by mrvodka

Title

Comparing numbers and associated labels

Post

I am using FileMaker Pro 7, and need some help.  I have 7 numerical field boxes that I will enter a number into.  Each data box has an associated field name box.  Not every box of the 7 will have a number in it.  I simply want the database to recognize the highest number from the 7 possible entries, put this number into a separate box and put the field name box associated with the highest number into it's own box.  For example:   

 

Test 1

Score 1 = 9

 

Test 2

Score 2 = 7

 

Test 3

Score 3 = 10

 

Test 4

Score 4 = 15

 

Test 5

Score 5 = 2

 

Test 6

Score 6 = 3

 

Test 7

Score 7 = 1

 

Output -

Highest Test =  Test 4

Highest Score = 15

 

I'm not sure how to handle this in the field options box.  Sorry if this seems like a basic question to you gurus, but any assistance would really help me!  Thanks. 

Outcomes