Link to home
Start Free TrialLog in
Avatar of allenkent
allenkentFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Doug
Doug
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allenkent

ASKER

Site Column is an interesting idea. thank you.