Original Post by Sandy (Imported from Ardevia Forum)
Hope you can help me.....
I have a list called Customers that has 4 columns on it:
Name; Contact Name; Account Number; Email.
I have a second list called Orders that has a lookup column titled CustomerName that does a Lookup on the Customers list using the Name on that List.
I have also selected to include the Contact Name, Account Number and Email on my Orders list which I selected at the time I created the lookup column on the Orders list.
What I am trying to achieve here is that if someone partially enters a Customer Name, selection will be allowed of an existing Customers list item, this should then display the Account Number, Contact and Email Address into the Orders Sublist on the form for verification purposes. How is this achieved?