Relative functorial semantics: Adjointness results