Charles, You cannot use a subquery for one of the values in a BETWEEN condition.
Try something more like: RULES 'Value for AnswerInteger cannot be outside allowed range.' + FOR `ttAnswers` + SUCCEEDS + WHERE AnswerInteger >= '1' + AND answerinteger <= + (select QuestionScale from Questions q2 + where a1.questionrecno = ttAnswers.questionrecno) Bill On 16 Jul 2004 at 12:27, Charles Parks wrote: > 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) > -- Bill Downall [EMAIL PROTECTED] 317.297.3810 ******************************** Notice: The ISP for our domain, SBC Ameritech, is currently having a problem keeping up with the volume of email and spam going through their mail servers. This means that sometimes mail gets through to and from us immediately, and sometimes the SBC Ameritech web hosting mail servers get constipated, so that delivery of mail to or from downallconsulting.com can be delayed by as much as half a day. If your message is urgent, please follow up with a telephone call. *****************************************
