Using Sharepoint Lists

[Greg McAllister]

I am generating an Infopath form wizard in Visual Studio. So far all is going
well up until today. I need to access several lists that are maintained on a
Document Control Management site. These lists contain information that is
needed to generate lists boxes within the wizard. The lists need to be
queried based on wizard selections. As an example - Joe wants to start a
document change. He is asked what type of chage he is making and he selects
type 1 and type 6. Based on those values I need to query a mangaed list on
Sharepoint that would retrive the type od documents that are affected by thos
change types, example - Quality Document and Custom Re., Sheet. He then
selects, in a multiple select list box, the document types he will be
changing. The final step is for the wizard to go to another managed list and
retrieve a list of authorizers for those type of documents and populate
another multiple select list that the user will select who needs to sign the
document.

Basically what I need to know is how do I get a list, preferably filtered
from the Sharepoint Server and use that data to populate the Multiple Select
List choices?

Thanks
Greg McAllister

 

[Adam Harding]

Greg

I can try and help you with some of this.

First thing to do is link the sharepoint site to a blank form as a new
dataconnection.

Then add queryfields to the form from the sharepoint site. Such that if
Type1 is selected it means something to the SS(sharepoint site) etc.

Now you need to add a query button that queries the sharepoint site for all
cases where Type 1 = Type 1 etc.

Now you need to show the data. Add datafields from SS to present the data.
probably a repeating table that allows for the showing of multiple results.

You would then need a datafield from SS to select change on each line of the
repeating table.

You would then need another button to query the main data source for the
Authoriser's name only showing the Authoriser's Name where they are listed to
Authorise this type.

Then another selection that forces the Authorisation persons email address
into the send to field in your additional dataconnection

and hey presto it will work

I hope this helps


Cheers Adam

 

[Greg McAllister]

Adam:

Thank you for your assistance. Please stay posted here as I try to give it a
shot. Will let you know as I prograss.

Greg

 

[Greg McAllister]

Adam:

After further review I think the problem was not understood. I am writing a
wizard in VB using Visual Studio and I cannot find examples of using the wss
list contents because I cannot find a way to use the data connector in VB.

The reason for this is that I will use the wizard to populate the form
instead of using list boxes on the form. The form has a specific layout that
does not allow for these types of things. Therefore I must preselect the data
then stuff it into the form into individual field. Needless to say that is
not a problem. What is is trying to link to the data connections using VB and
WSS Lists.

Do you have any further suggestions? Thanks again and am still trying to
come up with an answer

Greg