Solved

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

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 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