How to retrieve data from a child table

Need help Database
1

I have the following tables:
User
User_Rank table: User, Rank_ID
Rank table: Rank_ID, Rank_Name

When the user clicks on a button Rank,
I would like to retrieve that user’s rank from the User_Rank table and get the Rank_Name from the Rank table.

I need help figuring out how to do that.!

Here is a link to the picture of the tables.

2

Hi there, @tinhthanhd… with that structure in place, you could do a search for a user rank’s rank ID’s name, and the constraint on the user rank search would be where the user ID equals the current user. So, in other words (or image, as the case may be), something like this…

rank
rank698×342 16 KB

Does that make sense?

Best…
Mike

3

Thank you, Mike. I will try it.