2 Part question, 1st is how do I query just the possible choice values in a sharepoint choice column? I have a connection that queries the list for that value, but it returns all EXISTING choice values in the list, as opposed to the possible choices I have set in the column.
Example: In the SharePoint site I have a choice column with 5 choices..
1. Submitted
2. Processing
3. Reviewed
4. Approved
5. Denied
Now, assuming I only had items in the SP list with the values of Submitted, Processing and Reviewed, the form will only retrieve those values. I need to query the available choices, not the choices that I've already set manually from SharePoint. Is there a way to do this using the services? (asmx pages?) I would prefer to do this without code.
2nd question:
I have a list of old and new infopath forms on sharepoint, and I need to add this choice value to all of them, even the old forms. Is there a way to add this value to the sharepoint list without changing the XML for each and every form? I need to be able to edit the value in datasheet view, but any form that exists before this property is blank, and I see the SharePoint values in datasheet view, but when I select one and save my changes it says "Another user has changed the structure of this list. All Pending changes will be discarded. To view the latest copy, hit refresh." After hitting refresh the item then disappears from datasheet view. I can still see it in designer, but it's no longer in my view. Does anyone have any idea why this is happening? Is there a way to easily assign this column to old forms without individually updating the xml and schemas for all of the old versions?