search between 2 values
hi, first i am completely new to filemaker. And staring to learn with each step. But this i cannot solve.
lets say i have a table as follows
result / minimum value / maximum value / system
A123 / 0 / 5 / NIMH
A47845 / 5 / 10 / NICD
a1684 / 5 / 10 / NIMH
A984 / 10 / 20 / NIMH
A5218 / 20 / 30 / NIMH
I have a field in a layout where i write "9 "and another "NIMH"
in the 3th field I need the result.
so a search looks for the value 9 ( what is between 5 and 10)
and it must be NIMH. the result a1684 is written in my 3th field.
Ive looked everywhere for a solution as GET or Find or LOOP. And after 8 hours i give up. even youtube is not working