English Query

Entity <ObjectID> is a subentity of itself.

Message Text

This entity is a subentity of itself, due to a loop in the subentity hierarchy. One of the entities in this hierarchy should not be a subentity.

Explanation

The subentity hierarchy cannot be circular. It must go in one direction from the subentity to the parent entity. The following examples show an incorrect hierarchy:

This error occurs when:

Action

To prevent this error:

To correct this error, redirect the join and make one entity a subentity of the other:

  1. In the Join/New Join dialog box, correct the joins between the table so that they point in the right direction. In the Military Personnel example, point the join for Enlisted to Military Personnel and delete the join from Enlisted to Officer as seen in the following diagram:

  2. In the Advance Entity Properties dialog box for the subentity, on the Semantics Properties tab, in the Is subentity of list, click the parent entity. In this example, Military Personnel would be listed in the Is subentity of option for both the Enlisted and Officer entities.

See Also

Compile-Time Error Messages (Authoring Object Model)

How to add a join

How to delete a join

How to edit a join

Join/New Join Dialog Box

Semantic Properties Tab (Advanced Entity Properties Dialog Box)

Specify Join Path Dialog Box

SQL Database Normalization Rules

Table/New Table Dialog Box