Query data from an external MS Access database
Posted on 2011-04-20
I am new to InfoPath. I want to develop a form in InfoPath 2007 and then publish it to a SharePoint 2010 site.
I have created the form in InfoPath. It has a text box, a button, and a repeating table. Aslo I have added an external data source, which is an MS Access database. My idea is that users enter a part number in the text box and click the button. All the records in the database that match the part number entered into the text box will populate in the repeating table.
I have set up a rule for the button with a condition that the value in the text box is equal to the part number field in relevant table of the database and an action to query the data connection.
The repeating table is binding to the relevant table in the Access database.
With that, I tried with preview to test the form. Upon pasting over a part number and clicking the button, nothing happens in the repeating table. I have made sure that there are matching records in the database.
I also put in a drop-down list in the form to test the data connection. The drop-down is displaying info correctly. So I ruled out the data connection factor.
Therefore, the problem seems to be that I didn't configure the form properly.
Being new to InfoPath, I have no clue where to go from here. Can anyone point me to the right direction?