AnsweredAssumed Answered

Extract unique records from related table

Question asked by matthewsknight on Feb 26, 2017
Latest reply on Mar 1, 2017 by philmodjunk

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!

Outcomes