Hi
I am stuck on the design of a workflow I am working on. Basically, we have a main list on our sharepoint site and there will be several other lists which will be filtered lists of the main list. If you imagine you have, say, a status column on List A and in List B you only display those items with their status of "Completed". This bit was easy and all works fine.
Now, in a workflow I am building one of the tasks will be to select one item from a filtered list. By that I mean, one of the filtered lists (list to be used will be determined at run time based on certain criteria) will become the data source for a drop down list. The user then selects one of the list items in the drop down.
The problem I am having is that Forms service in InfoPath won't allow me to bind to a list (I need to make the data source items repeating and I can't bind to a repeating group with forms service on). If I turn off forms service, I can do it. But that would mean the task form would be opened in the InfoPath client application. I need it to open as an aspx page (i.e. use Forms Service). I don't fancy having to write my own task aspx page as I am sure I should be able to use InfoPath and writing my own aspx page seems like over kill and will be very, very time consuming.
Does anyone know how I can achieve my aim in InfoPath (if at all)?
Many thanks