Alpha Video Training
Results 1 to 2 of 2

Thread: Field Validation

  1. #1
    Real Name
    Bob Kenworthy
    Join Date
    Apr 2000

    Default Field Validation

    Hi Everyone,
    Happy New Year!
    I have a field validation rule that is:
    KEY_UNIQUE("game_id") and it works fine. This is on a subform that has a "Cancel" button that besides canceling the record it also disables the form. If the field rule shows the message "Record has already been entered" I can't get to my "Cancel button because I can't get out of that field. The only way to cancel the entry is with "Right click, Cancel". But the the form is not disabled. Is there a way for me to disable the form also?
    Thank you

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000

    Default RE: Field Validation


    Your field rule is defined at the table level. I don't know of a way to modify its behavior that will interact with the specifics of your form. You will probably have to develop a custom validation script that works at the form level. Such a script would check the value of the 'game id' field and compare it to others in the table. If not unique the script would alert the user and cancel data entry, otherwise it would permit the record to be saved. You could attach such a script to the CanSave event.

    -- tom

Similar Threads

  1. Field Validation
    By richard dymond in forum Alpha Five Version 6
    Replies: 7
    Last Post: 09-21-2005, 05:14 AM
  2. Field Validation - double entry
    By Tom Patten in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 05-20-2005, 11:53 AM
  3. Form field validation problem
    By Imran Ahmad in forum Web Application Server v6
    Replies: 3
    Last Post: 02-25-2005, 03:36 PM
  4. Conditional validation in field rules
    By Tommy in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-09-2002, 07:09 AM
  5. validation field rule
    By Becky McNichols in forum Alpha Five Version 4
    Replies: 5
    Last Post: 02-03-2002, 06:58 PM


Posting Permissions

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