1 Reply Latest reply on Dec 14, 2009 9:12 AM by mrvodka

    Comparing numbers and associated labels

    mattd

      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.