SharePoint 2010: Adding Lookup as additional field

Posted on 2011-05-10
Last Modified: 2012-05-11
Good morning!

I have three lists:
- Project (ID, Title)
- Backlogs (ID, Feature Name, Title (Project) FK, etc)
- Sprint Tasks (ID, Task Name, Feature Name (Backlogs) FK, etc)

In the Sprint Tasks list, I have a reference the Backlog's Feature Name as a Lookup value:
- Column Type : Lookup
- Get Information From: Backlogs
- In This Column: Feature Name

I am looking at the check box list: "Add a column to show each of these additional fields:", and I noticed that the Backlogs.FeatureName does not exist.

I've read online that Lookup column types are not supported as "additional field" types.  This makes little sense to me as I have a ligitimate need to display the project title for the backlog assigned to the sprint task.

Any ideas?
Question by:Unionblitz

    Author Comment

    LVL 14

    Expert Comment

    I think the Backlogs .FeatureName will actually be in the lookup field and the "additional" fileds are displayed in the checkbox list you are referring to. Am i missing something?

    Author Comment

    abhitriq, thank you for posting.  
    1. The "Sprint Tasks" list uses the Backlogs "FeatureName" lookup, yes.
    2. The "additional" fields displayed doesn't show the [Backlogs].[Projects].[Title] field.

    Is there a way to fix this?

    Author Comment

    LVL 14

    Accepted Solution

    Unfortunately no...
    1. Create a hidden field, say ProjTitle and update it with the selected Project through a eventhandler/workflow
    2. Use the Cascading lookup control (3rd party option) to link the lists and then filter it
    3. Use SharePoint designer to create a custom page and link the lists.

    Author Closing Comment

    unfortunately this is the closest answer to this problem.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    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…
    We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    755 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

    21 Experts available now in Live!

    Get 1:1 Help Now