Field Validation between 2 different Table

Hi  I am trying to find a way to validate some data within 2 Table. Relationship setup are Many to Many Both . The purpose of this is to validate most of the data between 2 table.    1. First I w...