W
WDSnews
In my Relationships, I have instances where, in one case, tables such as the
People table need to reference itself, or in another case, a related table
needs to reference two different records in the same table. For example,
should I reference a single instance of the People table in the
Relationships Manager, or should I add a second instance, People_1, and
reference it too? I've been using the latter without any noticable
problems, but I'd like to hear your opinion. The same situation exists when
building queries.
i.e. In the People table, children need to reference their biological
mother in the same table. Should I let People.Mother point to People_1.ID,
or back to the same table at People.ID?
i.e. In the Teacher/Student relationship table there are fields called
Teacher.ID and Student.ID that both refer to the People table. Should both
foreign keys point to a single People table or should one of them reference
People_1.ID?
thanks for your opinion about the Relationships Manager and about query
relationships.
People table need to reference itself, or in another case, a related table
needs to reference two different records in the same table. For example,
should I reference a single instance of the People table in the
Relationships Manager, or should I add a second instance, People_1, and
reference it too? I've been using the latter without any noticable
problems, but I'd like to hear your opinion. The same situation exists when
building queries.
i.e. In the People table, children need to reference their biological
mother in the same table. Should I let People.Mother point to People_1.ID,
or back to the same table at People.ID?
i.e. In the Teacher/Student relationship table there are fields called
Teacher.ID and Student.ID that both refer to the People table. Should both
foreign keys point to a single People table or should one of them reference
People_1.ID?
thanks for your opinion about the Relationships Manager and about query
relationships.