Forum Discussion
Relate same table twice
We cannot make two relationships active at the same time for two tables here. Using an inactive relationship is a way. This article should be a good reference.
Actually, we don’t need two relationships in some situations. As dejanle posted above, if we have two tables as below. We can create a relationship between Sell-to_Customer_No and Customer_No to get Sell-to Custome_Name.
We can also get Bill-to_Customer_Name by creating a column using LOOKUPVALUE without relationship.
Bill Customer Name = LOOKUPVALUE ( DB2[Customer_Name], DB2[Customer_No], DB1[Bill-to_Customer_No] )
Best Regards,
Herbert
Hello Herbert and many thanks for your reply
The problem with your solution is that i don't want to determine wich relation has priority above the other.
Tey are both important to me.
But i think i have to work it in other way. Don't know how since the table is design like this. Maybe duplicating a table....but that can be "dangerous".
Anyway. Tks a lot.
Brest regards
Pedro
pedroccamara You providing a sample of what your issue is will go a long way in helping us determine a solution. Just throw down some sample data...
Does your scenerio look something like this?
DB1 DB2
Username Username Name
suser suser sample user
tuser tuser test user