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.