aliabbassipro

Get Total

Discussion created by aliabbassipro on Feb 21, 2017
Latest reply on Feb 21, 2017 by BruceRobertson

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.

thank you.

Outcomes