And I found this from MSDN http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/c382b04f-b55e-4c65-b9e8-b295b48eebd0
look like the answer is no if we want it OOB. From: lied...@hotmail.com To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Date: Thu, 5 May 2011 18:05:59 +0930 Hi Michael, Do you have tutorial or screen shot for these? I just can't get find way, does this being done through SPD or I need to modify the xml file? Many thanks Ken From: nemt...@msn.com To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Date: Wed, 4 May 2011 14:57:26 +1000 Check the association files (that description is available there) the ReadItem type fields in source BCS Entity. You need to have “Description” field to be available in ReadItem and in association Michael NemtsevMicrosoft MVPB: http://msmvps.com/blogs/laflourS: http://www.sharepoint-sandbox.com From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of ken zheng Sent: Wednesday, 4 May 2011 1:48 PM To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 that's right.From: nemt...@msn.com To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Date: Wed, 4 May 2011 13:11:12 +1000Your description and code stored in the same list, and you just want to use different field, right? Michael NemtsevMicrosoft MVPB: http://msmvps.com/blogs/laflourS: http://www.sharepoint-sandbox.com From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of ken zheng Sent: Wednesday, 4 May 2011 12:21 PM To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Thank you very much Michael, I can manage to create association fields that when you add/edit the item, you can pick up from another list, but in the view can you display description instead of code from another list? KenFrom: nemt...@msn.com To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Date: Wed, 4 May 2011 11:46:42 +1000There is a bug, that you cannot change the Key field once BCS Entity created. You need to delete entity and recreated it again.However, the “lookup” fields visibility depends on Association fields you have ticked. Check your source and associations fields Michael NemtsevMicrosoft MVPB: http://msmvps.com/blogs/laflourS: http://www.sharepoint-sandbox.com From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of ken zheng Sent: Wednesday, 4 May 2011 11:37 AM To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Hi Michael, I just used desinger to do that, look like once you create the external content type you cannot change the field to "Show in Picker"From: nemt...@msn.com To: ozmoss@ozmoss.com Subject: RE: BCS in SharePoint 2010 Date: Wed, 4 May 2011 11:16:18 +1000What is the BSC configuration? You need to tick “Show in Picker” item in BCS Entity (when design in SharePoint Designer) and all related fields should be visible. Michael NemtsevMicrosoft MVPB: http://msmvps.com/blogs/laflourS: http://www.sharepoint-sandbox.com From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of ken zheng Sent: Wednesday, 4 May 2011 11:02 AM To: ozmoss@ozmoss.com Subject: BCS in SharePoint 2010 Hi Guys, I am trying to use BCS to a sql database. Just wonder if I have a product group table and product table. In the product table, there is group code reference to the product group item. Could I create an external list for product but when they edit/add item, they can choose the group description rather than code. Is it out of box or I need to write in code? Anyone has link to the tutorials? cheers Ken _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
