Visual Linker with multiple paths leading to same table

[hyuan]

I am having problems linking two fields from one table both to another table. I get the message "The link you added caused a link configuration with multiple paths leading to the same table. You may want to consider reversing the links."

The two tables I'm trying to link are:
Transaction table with:
transaction_id (primary key)
internal_legal_entity
external_legal_entity

Entity table with
id_number (primary key)
name

What I am trying to do is display the name of the internal_legal_entity and external_legal_entity for each transaction by linking the the internal_legal_entity and the external_legal_entity to the id_number.

Is there any way to do this through the visual linker or do I have to find another way to accomplish this task?

Thanks in advance for any suggestions,

Howard

 

[IdoMillet]

Open the entity table for a second time and
assign it an alias.

Cheers,
- Ido