Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

linking two list using another column other than ID column

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
dkim18
Asked:
dkim18
1 Solution
 
PstryCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now