Ok, while I am digging and digging myself into the world that's called Sharepoint I come to the next challenge.
I have two lists Projects List and Project Issues. They both have an id field (which is not the ID field of the record) and a title. I created two calculated fields for both of the tables which combines the title and the number for displaying in other pages.
Project Name: First Project in 2008
Display Name (which is the calculated field): 2008-001 First Project in 2008
The calculated field formula is: =[ProjectID]&" "&[Project Name]
The field returns a string.
I also have a Worksheet list where my workers have to fill in their working hours. In this list I have two lookup fields. O
View Complete Post