Skip to main content
P
purvajab0002
September 29, 2021
Solved

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

  • September 29, 2021
  • 1 reply
  • 0 views

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.

Best answer by srinandhavin5120

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.

1 reply

srinandhavin5120
srinandhavin5120Answer
New Participant
September 30, 2021

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.

    Terms & ConditionsAccessibility statement