Results 1 to 3 of 3

Thread: Validation Rule

  1. #1
    Join Date
    Nov 2013

    Unanswered: Validation Rule

    Help. I need a validation rule where a Horse cannot be added that does not already have a Dam and Sire existing in the database unless either or both are not known. All i have got atm is ([Sire] IsNull) And ([Dam] Is Null) However it wont accept this due to it being in web (HTML) format. I can't force referential integrity either due it being in web format as well.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Given those rules the onlg valdation you can do is where the user supplies a stallion or filly and make certain they exist. If they dont then you either
    Reject the change
    Set the offending value to null
    Require furthervuser inervention

    You can (and I'd argue SHOULD) enforce referential integrity checks..... theres stuff all point using a relational db otherwise.
    Both the sire and dam are foreign keys pointing to the same table (presumably called horses). Both columns can be NULL
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2013
    it wont allow me to go into relationships, i am guessing it is due to the table format being html,i would rather enforce RI, do you know a way around this?

Tags for this Thread

Posting Permissions

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