Click here to Skip to main content
14,699,563 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have 2 Tables, Division & Department with Parent Child relation. DivisionId is foreign key in Department.
I have created External content types for these 2 tables with an Association in Department Content type in SP Designer and then External lists in a SP Site.
How to display Division Name instead of Division Id in Department external list.

additional information copied from comment below
I have created all CRUD operations of Division and Department using Web services. Then created External content types using the web service. Even then i dont get the Division name in Department list.
I dont want to change my database design and want to only put Divsion id in Department Table
Posted
Updated 14-Nov-13 2:35am
v2
Comments
Nelek 14-Nov-13 7:12am
   
Gautam 14-Nov-13 7:30am
   
I have created all CRUD operations of Division and Department using Web services. Then created External content types using the web service. Even then i dont get the Division name in Department list.
I dont want to change my database design and want to only put Divsion id in Department Table

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900