I'm trying to use a default value in an MS Access field that adds 1000 to the orderID field. So, the default value would be... =[orderID]+1000
But I get an error that "the database engine does not recognize either the 'orderID' in a validation expression, or the default value in the table CUSTOMER."
As far as I can tell, the syntax is correct. What am I missing?