Unanswered: Validation Rule Refering to Another Table
I am using Access 2007, trying to migrate an existing database into Access and want to set a Validation Rule for one of the fields using the values from a column in another tables. In the Design View for "thisTable" I've written a Validation Rule for one field like this:
IN (SELECT otherTable.[fieldName] FROM otherTable)
but, I get an error: "Object invalid or no longer set." The MS suggested help for this seems irrelevant.
Why doesn't this work? Any help would be much appreciated.