SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If a guy were to want to allow a user to change data in an external list (based on an ECT of a SQL Server Table), and he had a particular field in that list (say a status field) that only needs to be in 4 specific statuses (i.e. CREATED/READY/INPROCESS/BADORDER), is there a way to put in a drop down list when they go to “edit” the record and only allow these options via a drop down list for this particular field? If so, how does one go about adding this functionality?

share|improve this question

I think that you should crate statuses table in your SQL Server, then add association to your external content type. How to do this you can find in this post.

share|improve this answer

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.