InfoPath Dev

Hi. I am working on a project and need to use SharePoint as a data store. If I were to store all of the data needed for the project into a single list in SharePoint, the data would take up about 6000 rows (multiplied by 40 columns each). I'd like to avoid some performance and technical issues involved with pulling this amount of data into a form each time the form is used. Instead, I'd like to divide the data into logical chunks in separate lists based on location for example. This would result in multiple lists that have fewer records. Users of the form would be able to pull only the locations they should have access to which could involve data from several lists. I am curious if there is a way to merge or join data from multiple data connections (multiple lists) into a single repeating table?

I know we can use copytable to send data from a connection into a repeating table. Can copytable be used to bring multiple columns into one single repeating table? Is there another/better way to do this?

Thanks!

Hi again!

So - the restriction with CopyTable is only that the source and destination tables have the same number of elements and attributes. If all of your source tables in your secondary data source have 10 fields, and your destination table has 10 fields, you can certainly use CopyTable to copy from 5 (or 4 or 10, whatever) tables into the same destination.

If your source & destination table do not have the same number of elements and attributes, there are other approaches you can use - you can write an XSLT and use the Transform command in qRules - which tends to be extremely quick in performance, but can be harder to implement (especially if you are new to XSLT) or you can use this approach: http://www.infopathdev.com/files/folders/qrules/entry58577.aspx which is easier to implement, but not as speedy to run.