I currently have two tables in a SQL Server 2k8 database: Locations and Customers
The fields in the Locations table are:
- CusotmerID (foreign key joined to Customers table)
The fields in the Customers table are:
- ID (primary key)
Through SharePoint Designer, I have both tables set up as External Content Types of the same names as the tables and have created External Lists for each External Content Type. All CRUD operations are working perfectly. I added the proper Assocaiation
and I've set CustomerName to be the Title of the Customers External Content Type. I can currently use a picker for CustomerID in the Locations List and CustomerName is displayed properly. Also, the default DispForm also correctly displays the
CustomerName for any single Location record.
However, I would like to modify the default ReadList so the foreign key (CustomerID) will show the Title field of Customers (CustomerName). However, I am running into trouble finding out how to do this.
Any help with this issue would be greatly appreciated!!
View Complete Post