Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    13

    Unanswered: field validation based on other field's value

    Hi, friends:
    I have a question regarding how to set a field validation based on other field's value.
    For example, if the value of field Country is "Canada" then the field of SPECIFYcity won't be empty, else the field SPECIFYcity should be empty.
    Any suggestion?
    Thanks a lot
    Kai

  2. #2
    Join Date
    Sep 2003
    Posts
    26

    Validation by Calculation

    You can use validation by calculation on the city field and use:

    If(Country="Canada" and IsEmpty(City)=0, 0, 1)

    If the country is Canada and someone enters a city you can show a dialogue telling them not to enter.

    Hope that helps.

    Tim Cormier
    TSC
    http://www.fmdeveloper.com

  3. #3
    Join Date
    Nov 2003
    Posts
    13

    Thanks a lot --- Kai

    I will try it later. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •