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!

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

Adam Djuby

Adam,

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