[RBG7-L] - Specifying a value range

[Charles Parks]

Is there a way to specify a rule that verifies a column value range is between 1 and a 
value in a different column?

I tried this:

RULES 'Value for AnswerInteger cannot be outside allowed range.' +
               FOR `ttAnswers` SUCCEEDS  +
               WHERE AnswerInteger BETWEEN '1' AND answerinteger <= ans+
werinteger in (select QuestionScale from Questions+
 where questionrecno = questionrecno)

but it allows values that exist outside of the range.