Table Data

[Sadee]

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.

[AleksiAlkio]

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].