InfoPath Dev

I have a repeating table feild that currently lists all the doc's in one sharepoint document library.
Is there a way I can get the pull down feild to list documents from multiple document libraries?




Kip Bautista
KTB Dezines
KTBDezines@netscape.net

I do not believe you can bind a repeating table to multiple data sources. I know in other Microsoft development environments that would not be possible.

I have had a similar situation where I had two repeating groups in my schema, or two sharepoint lists in your case, and I wanted to display them visually as a single list. What I did was I stacked the two repeating lists and removed the footer for the top one and removed the header from the bottom one. You will have to do some other things but I was able to get it to look pretty nice visually.

Although, there are some disadvantages to this approach, which may not come into play since you are using a sharepoint list. If the repeating tables are editable, meaning the user can insert or delete rows, it does not work well unless you write your own insert and delete buttons and then orchestrate which repeating tables will be edited. If the end if the sharepoint lists are read-only this will work well.

vt_asparagus

Forget sharepoint, I found a way to through the SQL datadase to hook to. create a data connection the the sql server and in the tables get userdata you'll need to get into the sql tables and show all rows to find the coloum that the data is in you want to link to the feild.

A filter will need to be created in the field to show only the dtda you want.

Kip Bautista
KTB Dezines
KTBDezines@netscape.net

Agree with you completely. I personally would not advise the usage of a SharePoint list but that was what you were asking about.

Suggest from a scalability standpoint that you move to a web service to return your data. That will decouple your from future changes to your data source. For example, you switch from SQL Server to Oracle or SAP or whatever...