Solved

linking two list using another column other than ID column

Posted on 2010-08-24
1
285 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
ID: 33518612
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharrepoint 2010 DB size 2 29
Sharepoint Max date with criteria 2 57
Onedrive for business 3 36
CMAL Query - Jsom 1 54
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…
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…
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.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 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

11 Experts available now in Live!

Get 1:1 Help Now