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

On a page, I show an external list. The underlying external content type has an association to another external content type. I built this with sharepoint designer. In the list, the associated type is shown with it´s ID which is not very helpful for the user.

I would like to know if I can set the property that is displayed, e.g. the name.

I can influence the field displayed in the view/edit form by setting this field as title in the summary view of sharepoint designer, section "fields". (Note, "Set as title" is found in the upper ribbon.) However, this does not change the field displayed in the list, which is still the ID.

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted
  • First you need to build a view on the table which contains all table columns plus the additional columns that should be shown. Important: All column names must match exactly.
  • Based on this view, a ReadList and a ReadItem operation have to be added to the external content type and are set as default operations. Important: the additional fields must be set "read-only" in the operations if a create and update is intended.
share|improve this answer
add comment

Your Answer


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.