3 Replies Latest reply on Dec 5, 2013 9:29 AM by philmodjunk

    Validating a Field via a Related Table

    CathyAnderson

      Title

      Validating a Field via a Related Table

      Post

           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.