Validation Rule

[noob123456]

Help Needed. 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.

 

[Dewi]

Just give us a bit more info...
Is there an input form..what is the data source...what is your table relationship???
what do you mean by HTML format?

 

[plog]

If this is on the web, then this isn't a database issue but a programming issue. Before doing the insert you need to check the data for validity, if it fails don't continue on with the submission, instead let the user know via a prompt or a reload of the page with an error.

This can be done via javascript no matter the language you are scripting the site in, but it can also be done via the language you are handling the submission in. Again, this is more of a question to ask a forum that specializes in web programming.