Validation Rule Help!

[confidego]

Hi guys,

Under my table, I need to set a validation rule that checks for 'Delivery Date' to be after 'Order Date'

I tried [Delivery Date]>[Order Date] and it does not seem to work. I received an error from the system 'Invaild SQL syntax - cannot use multiple columns in a column level CHECK constraint'

I would like to seek out advice on how I can solve this problem? Attached is my table.

Thank you.

[RuralGuy]

Someone may correct me here but this level of validation should be done at the Form level and not the table level.

[pbaldy]

I agree with Allan. Here's an example:

http://www.baldyweb.com/BeforeUpdate.htm

[confidego]

Hi guys, thank you for your replies.

Does it mean, I absolutely cannot do it at Table level? My tutor once told me that it is possible.

[RuralGuy]

I thought MS had added table level triggers of some sort in ac2010 but I can not seem to find them.

[pbaldy]

In the immortal words of Ed McMahon, "You are correct sir":

http://blogs.office.com/b/microsoft-...-triggers.aspx

[RuralGuy]

That explains why I couldn't find them. I never think of macros.
Maybe they would be able to accomplish what the OP is looking for. I know nothing about them and would not be of much help in that event.

[pbaldy]

Could be, though I'm in a similar boat. I played with 2010 at a couple of Summits and during the beta, but I don't have it loaded on anything right now. I'm still using 2007 (and 2000 ) for production apps. I'm not a strong user of validation rules, but I wonder if:

>[Order Date]

would work.

[rpeare]

You cannot use a validation rule where:

• You want to call user-defined functions, or VBA functions beyond the ones in JET such as IIf() and Date().
• The user should be able to bypass the rule.
• The expression is too complex.
• The expression involves data in other records or other tables. (Well, not easily, anyway.)

From:
http://allenbrowne.com/ValidationRule.html

As was suggested above your data entry is really the place you want to perform the validation.