I am starting off to work in the Dataverse and Model Driven Apps and I have hit my first hurdle. I have 2 tables, one with customer details and another for customer site surveys.
In the Customer Site surveys form, I want a section where you can select a 'customer name' record from the Customer details table. So I have created a lookup column in the Customer Site survey table to the primary key (Customer Name) in the Customer details table. Now I can search all the customer names in the customer site survey form via the lookup / relationship with the customer details table. But how can I set up the customer site survey form so that when you select a customer name, you can also show other columns from the Customer Details table, like Customer email, phone number, address etc.?
I would like the option to have search or dropdown for customer name (Primary Key taken from the Customer Details table) in the form on the customer site survey table. And once you select the customer name, you also get other customer details for that specific customer, such as email , address, phone number etc.
See screen-prints to help understand what I need.
