Relationship over multiple tables

I'm trying to define a relationship from one table to every other table in the database. Basically, I have one table that contains the ID of an object, and the other tables are different objects with different fields. However, every group of objects is connected by the ID. Is there a way to write a new relationship that locates all of the objects with the same ID throughout the database?