Alpha Video Training
Results 1 to 3 of 3

Thread: Field Validation validates an empty field???

  1. #1
    Member
    Real Name
    Michael Beecher
    Join Date
    Sep 2003
    Posts
    36

    Default Field Validation validates an empty field???

    Here's the situation:

    I have a database which includes my active customers as well as former (inactive) customers. I have a field named ACTIVE and another field named INACTIVE which is to be marked with an "X" depending on the customer's status. I want to prevent my employees from accidentally checking BOTH boxes (believe me, it's happened). So, for the ACTIVE field I set up a validation field rule with a custom validation with the expression ISBLANK("inactive") so that the entry in the ACTIVE field is only valid if the INACTIVE field is blank. The trouble is, this validation rule seems to trigger even if I don't try to enter anything in ACTIVE. If I just "X" the inactive field, the error message still displays.

    Suggestions?

  2. #2
    Member
    Real Name
    Michael Beecher
    Join Date
    Sep 2003
    Posts
    36

    Default Re: Field Validation validates an empty field???

    Never mind.

    I've opted to use a field with a dropdown list instead. Much simpler.
    Last edited by mgbeecher; 08-02-2006 at 04:07 PM.

  3. #3
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,216

    Default Re: Field Validation validates an empty field???

    Michael,
    Why clutter with a checkbox you don't need. Only one is needed for status. Checked the logical result is .t. and if not checked the logical result is .f. Choose if you want it checked if active of inactive, but you don't need two.

    Mike W

Similar Threads

  1. Field() and Field Validation before import
    By John Fringer in forum Alpha Five Version 7
    Replies: 4
    Last Post: 08-02-2006, 12:08 PM
  2. Empty Table vs Blank Field
    By Mike Wilson in forum Alpha Five Version 7
    Replies: 6
    Last Post: 04-30-2006, 11:48 AM
  3. Grid component field validation (date field)?
    By Hansolo in forum Web Application Server v7
    Replies: 4
    Last Post: 01-26-2006, 11:21 AM
  4. empty date field
    By dik_coleman in forum Alpha Five Version 6
    Replies: 2
    Last Post: 11-01-2004, 08:02 AM
  5. Empty Field Warning
    By Keith Hubert in forum Alpha Five Version 4
    Replies: 12
    Last Post: 02-26-2002, 07:03 AM

Bookmarks

Posting Permissions

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