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.