Good to hear :)
Except now this is completely redundant (it won't work anyway):
function MyFoom() {
return DataObject::get( 'CustomSiteConfig', "`MyFooterItemID` = '{$this->ID}'" );
}
simply call $thatItem->MyFooter() to get the SiteConfig that FooterItem is related to.
Although personally I'd call that relation something a bit less confusing ($has_one = ['Site'=>'SiteConfig']; perhaps)