locked
BCS and Dropdown Fields RRS feed

  • Question

  • Hi,

    Here is my situation, can someone really familiar with BCS let me know if this is possible.

    I have an external table in SQL Server that I want to populate from another source and then let certain users within the SharePoint enviornment access that data and update/change certain fields.   I know that is possible with BCS and not too difficult to create.

    However, while a couple of the fields are text and freeform data entry, a few need to have some controls put around them and the users should only be able to select from some pre-determined values.   Some are simple like Yes/No or have static values that don't change that often.   However, a couple of the fields need to draw their value from the source SQL table and those value change on a daily basis.   So is is possible with BCS (either through SPD or VS) to bind the values displayed in a dropdown list to another data source?   I have been web searching for information and can't seem to find any.

    Is this possible?  If so, anyone have any links to help me out?   Thanks.  -Alan

     

     


    My Ramblings @ http://alanwhitehouse.wordpress.com
    Tuesday, January 25, 2011 6:55 PM

Answers

  • I think I just figured out my own question.  I am thinking that the Association function is what I was looking for.    Can someone confirm?
    My Ramblings @ http://alanwhitehouse.wordpress.com
    • Marked as answer by GuYuming Tuesday, February 1, 2011 6:37 AM
    Tuesday, January 25, 2011 7:53 PM

All replies

  • I think I just figured out my own question.  I am thinking that the Association function is what I was looking for.    Can someone confirm?
    My Ramblings @ http://alanwhitehouse.wordpress.com
    • Marked as answer by GuYuming Tuesday, February 1, 2011 6:37 AM
    Tuesday, January 25, 2011 7:53 PM
  • That would result in a picker i guess. Is there a way to get Dropdowns ?
    Tuesday, March 15, 2011 9:54 PM