This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

External Content Type (BCS) with a dropdown column choices from a different table

Question
0

Sign in to vote

I want to create an ECT with Create/Update method using SPD.

The dropdown choices should be also from another table in the database.

How can I achieve this?

----------------------- Sharepoint Newbie

Wednesday, April 8, 2015 1:15 AM

Answers

0

Sign in to vote
Hi,

It is not supported to create External Content Type with a dropdown column by OOTB.

For a workaround, you can use Custom Field Controls and jQuery to add Drop Down List to External List Form.

Please take a look at this article SP 2010: Customizing the forms for External Lists (BCS) in SharePoint 2010 by using Custom Field Controls and jQuery

Reference:

https://social.technet.microsoft.com/Forums/office/en-US/61ffb8a0-af16-4104-94f9-255ea1b8bdf0/dropdown-from-external-content-type?forum=sharepointcustomizationprevious

Best Regards,

Eric
TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
- Proposed as answer by Wendy DZMicrosoft contingent staff Wednesday, April 29, 2015 3:08 AM
- Marked as answer by Hemendra Agrawal Wednesday, May 6, 2015 5:10 AM
Thursday, April 9, 2015 12:45 PM