Fiel validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I want to validate the entry into a column based upon the values in
another column in another table.
Click to expand...

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
 
Back
Top