Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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