Solved

Sharepoint 2010 Custom Column - linked to External Data - autopopulate the other fields

Posted on 2013-11-12
2
510 Views
Last Modified: 2013-11-21
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?
0
Comment
Question by:allenkent
2 Comments
 
LVL 9

Accepted Solution

by:
skipper68 earned 500 total points
ID: 39647805
You'd probably be best to create CONumber as a site column instead of on the calendar.  When you create CONumber, make it a lookup type and check the boxes at the bottom to include other columns to bring along when CONumber is added to a list.

Then, add the new "CONumber" site column from the existing field list to the calendar.  Now, whenever you create a new item and choose a CONumber, it will populate the other fields.  I remember the first time I figured this out, I thought it was magic :-)

If this isn't clear, I can see if I can put something together to help.
0
 

Author Closing Comment

by:allenkent
ID: 39666514
Site Column is an interesting idea. thank you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now