Multiple active table relation: IF exist 1st relation THEN use it, ELSE use other

Dears ❤️ I would like to create a conditional relation between two tables.   To be more explicative as possible, I have a table (Database1) with Purchase Request created in a site [Division], and ...