Hi All
I searched for this but have not found anything specific enough.
I'm designing a form to be used as a Hospital Clinic letter. In one form
field i (or my secretary!) will be entering a number (biochemical result). I
would like this result to generate a comment in the next field.

Basically the number will range from 5 to 14. Any number less than 7.5 needs
to generate a comment of 'good control'. Values between 7.6 and 9 need to
generate a comment of 'control needs improvement' and values 9.1 or above
needs to generate a comment of 'dangerously poor control'.

Any help very gratefully received.

Thanks

Phil