I have a link between Entity A which is a super type and other entity X. This is a one to many identifying relationship (A to X)
The supertype A has multiple sub type entities (B, C, D)
Option for subtypes on A set to: subtree generation "Table per Child"
Because link is from super type to other entity, and a table per child is created, this implies that this will result in multiple relations.
Unique identifier on entity X is the relation. All have surrogate keys.
Intention is to end up with a table X where one and only one of the linked table (B, C, D) id's is filled.
Did not manage to do that in the logical model. When doing a reverse engeneering from a relational model created in Designer I end up with an arc on the relation.
When in logical model I'm unable to create such arc because DM only sees one relation and arc button does not get enabled when selecting entity and relation.
Can it be done directly w/o reverse engineering? What am i doing wrong?
Using DM 4.0.3.853