Using query result to populate fields - multiple results causing error

Alex A — Tue, 14 Feb 2012 22:00:53 GMT

The idea -- I'm using Infopath in a customer service area to gather data for transactions that are to be completed for the customers. The form is submitting to a Sharepoint list (on which later iterations will allow us to sign/approve transactions electronically, so it will be built out to include workflows for approval and processing), and what I'm trying to do is to build a search function into the form that will pre-fill the client information based on previous transactions. For instance, the CSR will input the client account number, and the query will go to the list to find the client's account name and address to pre-fill the form. So, the sequence I'm shooting for is:

Input search criteria
Click on button control to query the SP list
Based on filters on the list, set the field values on the Client Name & Address fields

For any search that has a single result, I don't have any problems, the information is filling in to the appropriate fields. The problem that I'm having is that I want to pull the Client Name and Client Address information from the first entry in the SP list that matches the account number. However, as there are multiple entries in the list for that account number, I'm getting the following error:

An error occurred in the form's rules or code. The number of rule actions or the number of calls to the OnAfterChange event for a single update in the data exceeded the maximum limit.

The rules or code may be causing an infinite loop. To prevent this, ensure that the rule action or event handler does not update the data which causes the same rule action or event handler to execute.

Here is the xPath for the query, with the filters that I built in (which are effective if there is only one entry for the query item, but causes the error if there are multiple occurrances):

xdXDocument:GetDOM("DATASOURCE")/dfs:myFields/dfs:dataFields/dfs:DATASOURCE/@Debit_Acct_Title[../@ACCOUNTNUMBER = xdXDocument:get-DOM()/my:wireData/my:TopSection/my:SearchGroup/my:SearchByAccountNumber]

So, what condition would I need to write into this in order to force the search to populate the appropriate data fields based only on the first hit on that piece of information?

Thanks for any help!

Newbie Questions

Using query result to populate fields - multiple results causing error