InfoPath Dev

 Hello,

I am new to InfoPath (using the 2003 version) and I have been trying to create master/detail pages from an existing SQL server DB. In trying to learn how to do this I have been using the wonderful example posted by Matt Faus posted at location http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-an-InfoPath-Data-Filter.aspx.

The problem I have is that, not matter how many times I try from scratch to recreate this I can not get the query to return only the specific search critieria. Each time I run the query it returns all records. From my previous experience with Dreamweaver this problem usually pointed to a mismatch in the binding between the entered value adn the returned unique ID, but I can not see what is wrong with this (or what I am doing wrong).

Can anyone assist with the most likely solution or can you point me in the direction of other 'dummies guides' to creating master/detail pages in InfoPath please?

Thanks

bmak 

Hi.

In InfoPath you enter a value into a query field and it will return only the records which math the query data.

So in your form set ID for example to 1 and then run the query.

The only record returned will be the record with ID1, if it exists.

I am guessing that is your issue.

I alsways recommend createing a new form, based on your tables and then just drag all the fields onto your view and use the query button to play with it.