Hello,
There are two different kinds of relationships that can exist in Aras Innovator.
- Items can be linked to other Items by using a RelationshipType. This can be seen in the Part BOM relationship where the structure of relating two Parts looks like: Part->Part BOM->Part
- Items can be linked only to a RelationshipType. We call this a Null Relationship. This kind of relationship can be seen in the Part Changes relationship where the sturcture looks like: Part->Part Changes. Notice that there is no second ItemType linked to in this kind of relationship
The Model is actually a Null RelationshipType off of Product with a structure like:
Product->Model. If we look at the Model ItemType, we can see that the "Is Relationship" flag is set to true to indicate this.
Because of this, you can get the
Product to Model relationship simply by querying on the Model table itself.
Chris
___________________________
Christopher Gillis
Aras Labs Software Engineer