Hi, I am trying to extract unique records from a related table, and need some help!
I have a database that is set up to manage a music group. Our schedule is organised into Patches, in which there are various Projects. There are 7 musicians assigned to each project.
From the Patches layout, I would like to be able to produce a schedule, which would list all of the musicians for the Patch. However, since the different Projects can use some (or all) of the same musicians, I only want each name to appear once. It would also be great if the projects that they're involved in could be listed. In other words I want to end up with a schedule that looks something like this:
Mark (Project1, Project3)
John (Project2, Project3)
Elise (Project1, Project2, Project3)
Thanks for any help – I'm sorry if my question isn't clear!