Solved

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

Posted on 2013-11-12
2
502 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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

757 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

19 Experts available now in Live!

Get 1:1 Help Now