(I am using FM Pro 4.1 for Windows)

I have two fields, Product and Version. Product is defined as a text field and is populated via a value list. I want Version to allow blanks (null) EXCEPT when the value of Product is "Other" in which case Version must have a value.

What would be the best way to accomplish this? (Assuming it CAN be done )

[This message has been edited by chandra (edited August 15, 2000).]

Shameless self-post to bump this thread back to top of the list in hopes of getting a response.

quote:

---

Originally posted by chandra:

(I am using FM Pro 4.1 for Windows)

I have two fields, Product and Version. Product is defined as a text field and is populated via a value list. I want Version to allow blanks (null) EXCEPT when the value of Product is "Other" in which case Version must have a value.

What would be the best way to accomplish this? (Assuming it CAN be done

)

---

Here is the basic procedure, you fill in the details.

Put validation (field level or through scripting, I recommend scripting it) on the Version field. The validation should generate an error ONLY if the value of Product="Other" and IsEmpty(Version).

Then perform whatever you want to do to correct the validation error.

I recommend scripting this because users have a hard time dealing with validation errors. Scripting them through the resolution to the error will give you better results.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=