We have a mysql database that contains columns of our customer IDs and customer names that we want to use these as a source for some dropdown selection boxes for list items in Sharepoint – Most likely through an ODBC connector
Ideally what we want to achieve is to have something like you can get using the following steps:
- Create a new site column
- Set it to ‘Choice (menu to choose from)’
- Enter choices in the Additional Column Settings for the items that should appear in the drop down list.
We want a column like above but without having to manually update the list of choices that appear in the drop down list. This is what should be pulled from the mysql database – probably just refreshing its self once a day.
Is this possible by writing a feature to create the column, or through some third party add-ons? Any help to point us in the direction of how to get this setup will be much appreciated.