Guys, I have a Integer field which a user can edit on thier profile. I don't want that number to smaller than 1 or larger than the value of another field - been scratching my head for days on how to achieve that - anyway you can help me with some ideas?

So the fields are:

• Text field 1 - cb_totalpax (yes unfortunatley this is a text field, I guess I could change it to an integrer field not sure if CB can do that automatically?)
• Integer field 2 - cb_uktfrpaxout

So the validation whilst user is entering or updating cb_uktfrpaxout should be something like if user input in [cb_uktfrpaxout] < 1 or > [cb_totalpax]
then error message

Anyway this can be done?

I tried using Query Validation but I guess I am not familiar with the syntax etc of how to structure the query

Thanks

Cliff

So i did this and the result was a browser error saying:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return ( (int) '5' <= (int) '2' )' at line 1

I'm not sure what the syntax error is - can you help? Sorry...