Show unique parent records for current user
Looking for a way to show a summary type list of items. In my application I have a Projects table and a Time Entries table. Projects can have many Time Entries.
I also have a Team Members table. A Team Member can have multiple Time Entries.
I'm trying to create a summary type report which would show the Current User a list of all Projects to which they have logged any time. I do not want to view each of the individual time entries, but just a list (non-repeating) of the project name.
Example:
Time Entries (table)
Team Member | Date | Project |
Bob Smith | 7/1/2024 | Project A |
Bob Smith | 7/2/2024 | Project A |
Bob Smith | 7/1/2024 | Project B |
Bob Smith | 7/2/2024 | Project B |
Sally Jones | 7/1/2024 | Project A |
Report would then Display:
Bob Smith
Project A
Project B
Sally Jones
Project A
Apologies for not being clearer or holding a greater understanding of the application. I was stuck in the mindset that I needed to create a Summary field (via table-to-table relationships). I had previously attempted an actual Summary Report, but the results I was getting only showed a total number, not the names. I believe I have created a Summary Report that gives me the essence of what I am seeking. It is built summarizing (by distinct count) the Related Project field. It is then grouped by my Project Name field then by Related Team Member. I should now be able to filter this report so that the results will be based on the current user. I do wish I could not show the distinct count column, but that is a small issue.