?
Solved

linking two list using another column other than ID column

Posted on 2010-08-24
1
Medium Priority
?
327 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…

593 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