Size Range Problem

[Stuart Taylor]

Not sure if this is possible...

I have 2 tables "Object" and "Viewer".

"Object" contains the fields:

Type

Height

Width

"Viewer" contains the fields:

Type

Smallest_Height

Greatest_Height

Smallest_Width

Greatest_Width

I am trying to figure out a relationship or calculation that will show the objects of a certain type and within the height/width range when entered into the viewer...

but alas.

So far i have failed

anyone got any ideas ... file attached:

best

Stuart

SizeRange.fp7.zip

[comment]

Reverse your inequality signs.

[mr_vodka]

Stuart please check your compare relationships again.

[Stuart Taylor]

Thanks guys...

I'll have to put this one down to jet lag

:doah: