How do you all join list view data? For example, assume employee items have corresponding employee HR item and a corresponding employee asset item and we want to see all items in a list view or grid. Here's a diagram showing the items relationships which are 1:1.
Our goal is to see a list view on a dashboard page joining the data from all of the lists similar to how we see list views in SharePoint
Thanks in advance,