Help - How to map the data between two tables (beginner task)

I'm working with the following task,
I have table(table1) has a one to many relationship with table2.
In my view, I have my 1st table(table1). Eg: CustomerName column in table1. When I click on that, I should get the rows of orders in table2 with same CustomerName.
What are our suggestions for completing this task?

Eg: In Order fullfilment app, When we click on a customer's name, we'll be able to see all of their orders.

  Discussion posts and replies are publicly visible