Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have a list, which contains schools with their names and addresses. We have another list, which has lookup field to that list on school name field. Since schools in different cities can have same name, when adding new item to the referencing list, user will see the same name twice and he will not know in which city that school is. Is there any out-of-the-box possibility that lookup field will render something like $SchoolName ($City) in the drop down list? Or any workaround?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

You could create a calculated column to concatenate concatenate([SchoolName], " ([City])" the values on the school list and use that calculated field in your lookup. Verified it works in 2007, so it should work no matter what platform you're on.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.