Check if value is in range

[macrabbit]

hi there,

sorry if there is already another topic like this, but i couldn't find it.

i have one db with 3 fields ( name, start, end ) with about 40 different ranges (start-end) and another db with 2 fields (name , value).

now i want to check if the value lies within the range (start -end ) and show only those who fit.

anyone ?

[comment]

Define a relationship between the two tables (let's call them Ranges and Values) as:

Ranges::Start ≤ Values::Value

AND

Ranges::End ≥ Values::Value

Place a portal to Values on the layout of Ranges.

[macrabbit]

arrrrg ! - so easy

i tried it like this but opened the portal in the wrong layout...

thanks for bringing me onto the right track!

-solved-