Hi all, I have a data modeling question. I have two tables: 1.

person

(

id

,

name

) 2.

relation

(

id

,

from_id

,

to_id

,

relation_type

) How can I define two separate relations (

person.id ↔ relation.from_id

and

person.id ↔ <http://relation.to|relation.to>_id

)? If I drag the blue relationship dot a second time, nothing happens. Currently, the only solution that works for me is creating two aliases of the

person

table (

person_from

,

person_to

) and defining relationships as follows: 1.

person_from.id ↔ relation.from_id

2.

person_to.id ↔ <http://relation.to|relation.to>_id

Is there a better solution? Example tables:

person
| id | name    |
|----|---------|
| 1  | Alice   |
| 2  | Bob     |
| 3  | Charlie |

relation
| id | from_id | to_id | relation_type |
|----|---------|-------|---------------|
| 1  | 1       | 2     | Friend        |
| 2  | 2       | 3     | Colleague     |
| 3  | 3       | 1     | Family        |

person_to
| id | name    |
|----|---------|
| 1  | Alice   |
| 2  | Bob     |
| 3  | Charlie |

Thanks!

Hi Peter, thank you for your question. I would like to clarify something, with 'tables' you mean a two different Data Sets in you LDM, and you are asking about the relation in between these two Data sets? Please could you clarify.

Awesome, thank you @Mauricio Cabezas