Table Data

AppSheet AppSheet Q&A
1

I have two tables :

1) Customers [CustomerID (type - Text), CustomerName (type - Name), CustomerPhone (type - Number), CustomerAddress (type - Address)]

2) Orders [OrderID (type - Text)]

**My query is that in the Order’s table Form_View, I want to get the list of all CustomerID (as a dropdown list) from Customers Table, when the user selects one of the CustomerID’s from thIS dropdown list, the respective CustomerPhone and CustomerAddress should get auto-**commuted and displayed to the user. Please help how to achieve this.

2

Add a Ref column to your Orders table and select the Customers table as a reference. Then you can use a Deref expression to read other columns and their values like [Customer].[Phone].