look up values from another application
I have a customer list form with account number, customer name, contact name, contact phone, and contact email fields..
I have a form 2 ...with a lookup field for account number...; customer name, contact name ... etc.,
When I select an account in form 2, I would like to fetch the corresponding values for customer name, contact name etc.. from customer list form..
I tried with the following code... and getting error
if (Customer_List.Customer_List[ID == input.Account_number].count() > 0)
{
x = Customer_List.Customer_List.ID [Account_Number == input.Account_number];
//input. refers to fields in current form
input.Customer_Name = x.Customer_Name;
input.Contact_Name = x.Contact_Name;
input.Contact_Email = x.Contact_Email;
}
Can anyone help?
Thanks