Answered

Table with many-to-many relationship

Like (0) Share

Report

Posted on 16 Jan 2023 13:11:49 by Veronica22

Hi, I would like to know if Dataverse allows you to have a view or to visualize the table from the relatioship many-to-many between two tables. For example, If I would like to have a resume of the association of two tables, can I visualize it on a table which contains the data from the two tables?

Categories:

All responses (2)

Answers (1)

Ethan_Power 115 on 14 Dec 2023 at 22:33:14

Like (0)

Report

Re: Table with many-to-many relationship

The only way I know to access the hidden many-to-many relationship table is through a Dataflow. You might be able to copy the contents to a new table in order to view the contents. I wonder if you could create another dataflow to feed the new table data back into the source data -- assuming you want to make edits. It's risky, but it might be worth the effort?
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on 16 Jan 2023 at 16:46:17

Like (1)

Report

Re: Table with many-to-many relationship

when you create a N:N relationship Dataverse create automatically a table with only the two primary keys of the connected tables, afaik there isn't a OOB way to display the content of these tables or content from both tables at the same time