AnsweredAssumed Answered

Validating a Field via a Related Table

Question asked by CathyAnderson on Dec 4, 2013
Latest reply on Dec 5, 2013 by philmodjunk


Validating a Field via a Related Table


     I have a table Paper with a field Paper 

Paper field holds the name of the paper ex. Power of Attorney - Medical

     I have a related table PaperSame with a field PaperSame

PaperSame (id_f_paper) is related to Paper (id_paper)

PaperSame field holds alternative names to the related paper ex. Health Care Proxy

     the field Paper is set to hold a unique value but  I also want to check all the records in PaperSame 

     to validate the field Paper is truly unique across both tables.

     I am assuming I need to use the "validate by calculation" to make this happen? But not at all sure how.