Hi all,
I was wondering if it would be possible to query a SharePoint 2010 InfoPath form library by a value in a repeating table. My application is as follows - we have one group of workers submitting InfoPath records, and one of the fields being submitted (basically a list of production orders) is an InfoPath repeating table. We also have another group of workers submitting a different form, where one of the (singular) fields is a production order. It would be useful to query the 1st form library's repeating table by the 2nd form library's single value, in order to return other values that were contained in the 1st form library's matched record.
I've attempted to do this, but so far have been unsuccessful. I've set lookup values and queried for data before using singular fields, but am unable to get it to work for a repeating table. Would something like this be possible? Thanks for your time, and any and all help is appreciated.
Thanks,
Jeremy