I am trying to make a field required but only if the value of another field is 'x".

Scenario - this is an issues submission form for production support of a much larger enterprise application - the field in question is "Description of Requirement". This should be a required field only if the value of "Issue Type = Enhancement".

I am a beginner, sorry for the ignorance.

Thanks in advance.

Jam

FileMaker Version: 6

Platform: Windows XP

Try validating based on the calculation

IssueType <> "Enhancement" or not IsEmpty(DescriptionOfRequirement)

It's a good idea not to use spaces in field names. Either concatenate the words with capital letters or use underscores.

NOTE: in the validation calculation, deselect 'Validate only if field has been modified'.

Thanks - It worked exactly as I wanted it to. To go one step further, can I limit which password/group can bypass this? i.e. SalesOps shouldn't have to detail the requirement when going through the list, however anyone else, i.e. the EndUser should.

FileMaker Version: 6

Platform: Windows XP