AnsweredAssumed Answered

calculation to find a number in an range

Question asked by dutchpete on Mar 31, 2014
Latest reply on Apr 1, 2014 by 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

Outcomes