Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.