InfoPath Dev

hi,

i've got a new problem :)...

for example: i created a access db, with 2 tables (1 table for the suppliers and 1 for the products [1:n]), and created a form in infopath and got
a connection with the access db. i have the queryFields and the dataFields on my form. it works, when i search for
suppliers. it shows me in the dataFields the entries. BUT when i search for a specific product, it shows me ALL
supplier-entrys and somewhere in the dataField-list the product and his supplier what i was searching for .....

how can i realize it, that he just show me the product-entry with his supplier.... ?

i've did it like this: http://office.microsoft.com/en-us/infopath/HA011199501033.aspx

I would guess it has to do with your table relationships.

You may need to create a seperate data connection for just products.

Do you have a lot of records?

I can show you how to also query your secondary data connections.