This post shows two ways of using relative lookup field queries in a multisite environment.