Relationship between two tables based off multiple columns?

Hi all,   Hoping someone can help me with this one as it's really got me stuck.   Basically I have four tables. One table is a Cost Centre hierarchy, with high level codes feeding into lower leve...