linking two list using another column other than ID column
Posted on 2010-08-24
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?