Lookup Field and Set Criteria optioin

Lookup Field and Set Criteria optioin

Hello,

I have just started using Zoho creator and it looks like a great tool. Unfortunately, due to mu inexperience with such tools I am already having a problem as follows...

I have created 2 forms (Classes and NewCharacter).
On the NewCharacter form there are several fields, one of which is Constitution.
On the Classes form there are several fields, one of which ConMinReq.

I am trying to add a lookup field (called Class) to my NewCharacter form.

When I add the field I want to use the 'Set Criteria' deluge script area to limit the classes displayed to those that have a ConMinReq value <= the Constitution value on the NewCharacter form. I try to use the following script in the Set Criteria box of the Lookup field...

ConMinReq <= NewCharacter.Constitution

When I click 'Done' to add the new field I get a message telling me Constitution doesn't exist in form Class. I know it doesn't exist in form class, but it DOES exist in form NewCharacter which is why I prefixed the Constitution field name with NewCharacter.).

I'm sure this isn't a Zoho problem - it is something I am doing wrong but I have been unable to find a solution in the forums or help guide.

Can anyone please help me?

Many thanks.

Rob