Relationship over multiple tables

Archived from the Xataface Users forum.

Byrhtwulf72 — Mon Apr 16, 2012 5:44 pm

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?

---

shannah — Sat Apr 28, 2012 9:40 pm

It sounds like you may need to set up multiple relationships, but I’m not exactly clear on what you’re trying to achieve so I can’t comment too much. Generally, for each table that your record is “related to”, you’ll have a separate relationship.