Linking of Sharepoint lists

[LennartWalldén]

I have an app that is a project management system and I have been using one list to contain all the data. Now I am working on a new version where I split the data to different Sharepoint lists. I want to have a list called ProjectList as master containing ProjectID and ProjectName and some other base data.

In antoher list called ProjectParticipants, I will have names of the project participants. The second list is connected to the ProjectList via the ProjectID. But I also want to display the ProjectName in the second list. Which is the best way to get the ProjectName from the ProjectList. I want to keep it maintained if someone changes the name of the project. I know that I can write a rename function which takes care of the problem, but is there a smarter way to link the lists and get an automatic update?

[timl · Accepted solution]

@LennartWalldén 

You can call the LookUp function to retrieve the ProjectName in the second list.

Let's say you display ProjectParticipants in a gallery control. In the gallery, you can add a label and set the Text property to:

LookUp(ProjectList, ProjectID=ThisItem.ProjectID).ProjectName

[LennartWalldén]

Initially I looked for  a way to create a direct link between the Sharepoint lists, but now I think I go for your solution which is easier and more robust. Thanx!