Formula or tool to access common field information between two tables.

I cannot figure out how to make relationships or formulae to solve my present dilemma. It feels like there must be an obvious solution. Any ideas are appreciated. If my table A has a an email a...