Hey Doug,
>Kind of a pre-validation.
Exactly.
>Would have to set up some conditional validation flag to keep the validations from firing again when the insert/update is issued though.
I don't think you're going to be able to do that. TABLEUPDATE() is going to check the rules when it tries to committ the changes.
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development