I ask this question before and I can't learn it.
this is very important to me so please if anyone knows the answer give it to me.
I have 3 tables: 1-Artists 2-Songs 3-Artists Songs
I want to show the user each artist have how many songs.
for example artist A = 20 songs. Artist B = 35 songs.
I want when the user goes to the next record can see that total field.
I know that I mast have to total fields. one of them total of all tracks and the other total of songs of each artist.
please help me to do this hard calculation.