Fiel validation

[Jimmy]

I want to validate the entry into a column based upon the values in another column in another table. I can't get the syntax right. I have tried 'In ([sourcecode]![accptsource]) and In ([sourcecode].[accptsource]). It works just fine if I use 'In (sourcecode)' but that isn't useful because it just checks against the fields values already entered into the column.

 

[Tim Ferguson]

I want to validate the entry into a column based upon the values in
another column in another table.

Can't do it in a ValidationRule -- field level ones only look at the field
in question, and the table level ones will only look within the same table.

It sounds like you are trying to set up a Foreign Key constraint -- so why
not simply use the Relationships Window to set up the relationship?

HTH


Tim F