You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An uncommon data model concept is a child table with 2 foreign keys to the same table. For example, an employee might have a WorksForDeptNum, and an OnLoanDeptNum - both Foreign Keys to Department.
The system currently restricts this (with an appropriate error), so you cannot have sums/counts in such cases. The system presumes only 1, and throws a "TODO - disambiguate relationship" exception.
It should be possible to add a Sum/Count property child_role_name to designate the intended relationship.
The text was updated successfully, but these errors were encountered:
An uncommon data model concept is a child table with 2 foreign keys to the same table. For example, an employee might have a WorksForDeptNum, and an OnLoanDeptNum - both Foreign Keys to Department.
The system currently restricts this (with an appropriate error), so you cannot have sums/counts in such cases. The system presumes only 1, and throws a "TODO - disambiguate relationship" exception.
It should be possible to add a Sum/Count property
child_role_name
to designate the intended relationship.The text was updated successfully, but these errors were encountered: