AnsweredAssumed Answered

Relationship issues.

Question asked by ultranix on Jan 25, 2011
Latest reply on Jan 25, 2011 by philmodjunk

Title

Relationship issues.

Post

I have a contacts database, and I have this issue:

Relationships between contacts and meet info, when I set them up like this, works fine:

CONTACTS::id_contact [indexed, auto-enter calculation, required value, allow override] = MEET::id_contact [indexed]

The real trouble is when I try to set relationships having TEAM table in between of it.

That's how i set relationship and I have to go to manage->database and update id_contact field manually in order to get this to work, otherwise, latest record doesn't show up correctly. This is the setting:

CONTACTS::id_contact [indexed, auto-enter calculation, required value, allow override] = TEAM::id_contact [indexed] = MEET_TEAM::id_contact [indexed].

How should I correct this relationship?

Outcomes