Sharepoint 2010 Custom Column - linked to External Data - autopopulate the other fields
I have a Calendar with additional custom columns. In the columns I have a field that I use Column Type : External Data. I can see my data and it works great. I can select my External Content Type and I select my external data from source called CUSTOMERORDERS.
I have a field named CONumber that I want to select. I want this to auto-populate the other fields in the calendar and it does not. Basically when I select the CONumber field I want it to auto-populate CustName and CustState and CustID. These fields are in my CUSTOMERORDERS table (external data set)
How do I just select the CONumber and these other fields just automatically populate the corresponding data?