Many-to-Many Relationships - Views as a source for a view
Many-to-Many relationships are powerful for many reasons; in particular action items that have many users that interact with them.
Please consider this scenario:
tblActionLog
FielduserCreator
FielduserAssigned
Field_userCompleter
...
A report to display all three users would be very useful, and an easy approach (easy from our end, IDK what this would require from your end) would be to use three User table views as a source for the view that would be the source for the report.
viewUserCreator, viewUserAssigned, viewUserCompleter, tblActionLog -> sources for viewActionLogReport
Thanks for your consideration
CHAD
-
Wayne Patterson commented
I do this with 3 tables, 1 view, and 2 data pages to display results on the same web page. Table-1 is for action items, table-2 is the list of people, and table-3 is for the many-to-many relationships between the first two tables. Table-3 also includes a field for the person's role with that action item. Both data pages are pre-filtered on the ID of the action record.