Link 2 columns from one table to another

[AkrMus]

I have a table that has these columns

CompletedHour and LoggedHour

both columns should link to the same Table2 column.

First link works perfectly

but when I try to activate the 2nd one I get error

"You can't  create a direct active relationship between Table1 and Table2 an active set of indirect relationships already exists between these tables"

how to fix that

[TeigeGao]

Hi @AkrMus ,

As mentioned by @parry2k , it is not supported to map create multiple relationship to the same column in one table. But why will you do that? Actually, CompletedHour and LoggedHour will be filtered differently.

Best Regards,

Teige

[parry2k]

@AkrMus you cannot have more than one active relationship between two tables, to use 2nd (inactive) relationship, you have to use userelationship function, read more here.