Hi,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
You should be having a foreign key mapping to table 2, something like CustomerId. You can use the CustomerId/CustomerName filter to query the data from table 2. Please provide more context if you still could not achieve this.