1 2 Previous Next 15 Replies Latest reply on Apr 1, 2014 8:52 AM by dutchpete

    calculation to find a number in an range

    dutchpete

      Hello,

      I have a question i can not find in any forum, can some please help me.

      i have 2 tables client and arrangements.

      on the client layout there is a dropdown field with age 18,19, 20 etc.

      In the arrangements table there are 2 fields "agefrom" and "ageto" , an arrangement is based on a age range 18 to 27, 27 to 35, 35 to 50, 50 to 65

      the dropdown age will trigger a script and puts the age in a variable $$age.

       

      now i want to perform a find what finds all records where $$age is a part of the above range or not.

      i tried all possibilities with find mode in script , but its not working, can some please give me a hint where to start.

       

      thanks

      very much

        1 2 Previous Next