Hi, I have a database where I would like to select data from a list box, the data in the list box is Small Medium and Large.

When I select small I would like the db to auto enter the number 1 into another field. When I select Medium I would like it to auto enter 2 in the field.

How is this done?

Thanks for any help

Chris.

FileMaker Version: 7

Platform: Windows XP

You could set the auto-enter option for the number field to "by calculation"

then use an if or a case statement to make the result dependent upon the other field.

Dana

Or simply define the "number" field as a calculated field using the same calculation