INFOPATH keeps returning ALL the records (with the "...large amounts of data..." warning) when I enter a word into a box in the query section of a form! It doesn't seem to select records that contain the word entered in the box.


Not sure why it is doing this. Please help


The form is linked to an access database containing 2 tables linked by a one to many relationship (using the main tables ID, its primary key)


1st table = main = all data apart from key words
2nd table = key words only = linked to 1st table as one to many

The keywords are entered in the data section of the infopath form as a repeating table (so there can be 1+ key word per record) and are
submitting data successfully.


But when I type in the query section one of these KEYWORDS it returns
all of infopaths records and am not sure why... any ideas?

Did you ever get an answer to this .......

I suspect that each of the query sections only apply to the individual tables.

or more accurately, the 2nd table criteria is applied to the result set of the first table (but does not exclude 1st table entries).

I created my own similar topic :

http://p2p.wrox.com/topic.asp?TOPIC_ID=66946