Forum Discussion
Systemuser table mutiple relationships
I believe that one way to solve this would be to download the Systemuser table 3 times. I would name the tables "Owner Users", "Create Users" and "Modify Users" or something similar to tell them apart from one another. Relate each of the columns in the entity table to its corresponding Systemuser table. Then you can use the column from each of the 3 tables in the same visualization.
I believe that one way to solve this would be to download the Systemuser table 3 times. I would name the tables "Owner Users", "Create Users" and "Modify Users" or something similar to tell them apart from one another. Relate each of the columns in the entity table to its corresponding Systemuser table. Then you can use the column from each of the 3 tables in the same visualization.
Thanks Greg_Deckler yes sorry it was a daft question, solution was really obvious I should've worked that out myself!
Thank you.
Actually I tried this and my Created By field and my Modifed By field using RELATED('Tablename[column]') are blanks. Owner is still working and yes they are all mapped in the relationship screen
I don't think that you should need any kind of formula but I may not be understanding the issue correctly, I guess what I envisioned was that you had a main table with an numeric ID in your three columns you mentioned. Each of these is related to one of the three System User tables by that ID but they also have the name of the individual. In this case, you should just have to create a table visualization with some column from your main table and then just drop in the "Name" columns from your three related tables and everything *should* work.