Solved

linking two list using another column other than ID column

Posted on 2010-08-24
1
276 Views
Last Modified: 2012-05-10
Hi,

1) Is there a way to access items in list with different column instead of ID column?

Say I have Projects and Tasks lists.
Projects list has the following columns: ID, ProjectName,ProjectNo,LinkToTask(if any)
Tasks list has the following columns: ID,TaskName,ProjectNo,TaskNo

2) From Tasks, I can use the lookup to link ProjectNo but how can I create a link on Projets to hyperlink to Tasks?

0
Comment
Question by:dkim18
1 Comment
 
LVL 4

Accepted Solution

by:
Pstry earned 500 total points
Comment Utility
This should be possible.

I have checked this configuration and it works. Make sure that TaskNo and TaskName are text fields. You can create lookup fields that reference number, text, datetime, some computed and calculated fields.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

7 Experts available now in Live!

Get 1:1 Help Now