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.
LinkedIn
Twitter
