Dynamically get an associated field?

This is a slightly convoluted scenario.  I'll do my best to describe the situation.  I have two tables with related but not identical data.  The project number is the key in the Projects table and the...