AnsweredAssumed Answered

Help with field validation calculation

Question asked by sunnysundaram on Nov 6, 2010
Latest reply on Nov 9, 2010 by sunnysundaram

Title

Help with field validation calculation

Post

Hi all

I am beginner in filemaker. I am creating a database file for my neonatal unit

It has got two number fields

1. Gestation (has got a value list (from 22,23, 24 to 42)

2.Weight 

I want to validate the 2nd field (weight) so that it checks the numeric range entered for the second field(Weight) based on the choice of my first field(gestation)

eg. If I choose 24 in the gestation field, the weight range that I can enter is from 200 - 1200

     If I choose 25, the weight range that I can enter is from 300 - 1400 

If other value is entered , it will display an error message

Help please

Regards

Sunny

Outcomes