English Query
Entity <ObjectID> should be represented by table <tableid>.
Message Text
The field that represents this entity is joined to the key of another table. The entity should be represented by the other table rather than this field.
Explanation
This entity is represented by a field that has a join to the key of another table. For example, if a Branch entity is created from the Branch ID field in the Employee table, an error occurs. The error occurs because a join exists from the Branch ID field of the Employee table to the ID field of the Branch table. Make the entity a table entity and point it to the Branch table as seen in the following diagram:
Action
To prevent this error:
- Represent the Branch entity by the Branch table.
To correct this error:
- In the Entity/New Entity dialog box, click Table. In the Table list, click the table containing the foreign key and in the Field list, click the fields you want to display.
Note Make sure that the appropriate join exists.