How do I find the data from the table's table data?

Questions
1

Hi all, I’m a new to bubble so my question may be very basic but need your help !

I have tables and fields as follows

  1. User

  2. Main Musician

  • User = User
  1. Music Album
  • Musician = Main Musician

User can have multiple musicians (User is like a music record label)
Let’s say User have 3 musicians.

  • Musician A, Musician B and Musician C
  • Each of them has one music album so total of 3 (Album#1, Album#2, Album#3)

I’d like to display all music albums of all musicians for the User,
which are Album#1,#2,#3 of Musican A,B and C

Can anyone help how I can display them in a repeating group?

I tried this :
Seach fo Music Albums
with constraint "Main Musician = Search for Musician:last item(user = current user)
But it only gives me the last musician’s album = Musician C
I want all musicians’ album to be listed

22132

Please help !

2

Do a search for Music Album and that will

3

Thank you for your reply!

But then, it will display all other users’ musicians’ albums, isn’t?

I need the user’s musicians’ albums only be displaying, not other users.