Two relationships to same table. Is it possible?

[joebwan]

If I have a table with ID1 and ID2 fields that match the ID field in another table, can I have two relationships going where each ID refers to a different record? Something where I can get ID1->Name or ID2->Name. Initial experiments aren't yielding an obvious answer. Is such a desire too complex for the relationship system in Filemaker?

[MoonShadow]

You say 'table' so I assume you are using vs. 7? Please update your profile.

Just create a second table occurence. The first would be ID1 > Name and the second would be ID2> Name.

ID1 maybe holds a staff code for every staff. ID2 hold a Supervisor code (which could also be a staff). The first Table Occurence could be called Staff (relating only to ID1) and the second Table Occurence could be called Supervisor (only relating to ID2).

Not sure what you're working on here, but I hope this gets you moving forward anyway. If I'm off mark, just explain a bit more and we'll help you; and no, it isn't too much for FM7.

[joebwan]

I figured it out. I had to create a second (clone) table in the relationships graph. Dragging two fields to create a relationship just made the single relationship into an "AND" relationship.