INVALID SQL syntax

[Dopeyjh]

Hi,

I am receiving this error;

"Invalid SQL syntax, cannot use multiple columns in a column level CHECK constraint."

Without explaining my disaster of a situation anyone have any ideas?? haha

Thanks.

 

[Fear Naught]

Why not post the SQL statement that is giving you the error then you might get some feedback.

 

[The_Doc_Man]

I think you must have a field-level validation that says (for example)

[This-field]>[other-field]

or any other formula that (for table-level validation) involves something that is non-constant. Please note that this restriction does not apply to forms. Only to the table's field validation definitions.

Also, that error message looks more like a passthrough than a native Access message. Is this a case where the data tables are on a back-end server?

 

[Dopeyjh]

I'm trying to enter a validation rule in a field. Where it looks up the dollar amount in one field and if it is less then the dollar amount in another field then enter an error message.

I know the expression that i want to use, or at least i think i do . I believe the problem is, that the second field that it is looking at is a combo box with two fields in it..The first field being employee name and the second being dollar amount. Is there a way that i can tell it to look at the second row in the table?


I hope that made sense..
Thanks for your help.

 

[Dopeyjh]

Thanks Doc Man, that is exactly what i am trying to do, how do i do that on the Form?