Show 1 occurrence in a portal

[Sam]

I have created a database in FM8 to design a worship service for a church. I have 2 tables, 1 is the Service table and 2 is the songs table.

I want to be able to view a list of songs sung in the past by 3 groupings.

1. Songs sung the least

2. Songs sung regularly

3. Songs sung the most

By choosing a group such as the “least sung”, I want it to display the songs in the portal.

My question is, how can I get the portal to display each song only once, rather than multiple times, even though the song has been sung more than once.

Thanks for your help!

[Osman]

I think you can do it by splitting songs table (to srote songs) and play history table (to store playying informations)

Adam Djuby

[Sam]

Adam,

I'm not quite following you. Can you explain in more detail?