AnsweredAssumed Answered

Printing Lists without duplicate information

Question asked by Pwrjnky on Apr 14, 2010
Latest reply on Jun 2, 2010 by Pwrjnky

Title

Printing Lists without duplicate information

Post

I have a large collection of sheet music from movie and broadway productions. I want to print out a list using only two fields: (1) the song title, (2) the production it was featured in. The list will be sorted by the production name. In some cases I have several songs from one production. In these cases I don't want the production name to be repeated for each song. How do I do this?

 

I want it to look like this:

 

Production                         Song

Anything Goes                   All Through the Night

                                             Anything Goes

                                             Blow Gabriel Blow

Around the World              If You Smile at Me

                                             Look What I Found

 

Not like this:

 

Production                        Song

Anything Goes                  All Through the Night

Anything Goes                  Anything Goes

Anything Goes                  Blow Gabriel Blow

Around the World             If You Smile at Me

Around the World             Look What I Found

 

 

FMP11

Mac OS 10.6

Little experience with databases

 

Outcomes