Infopath-Webservices-SQL server

[swethabilla]

Hi, I am facing a problem while trying to retrieve data from a SQL
server database through the webservice. I did the following.

Created a simple database with two tables customer and Product withe EMP_ID being the primary key in customer table to establish a relation with the product table.

In visual studio I established a SQLconnection, SQLdata adapters for the two tables andthe dataset.

established a relationship (nested) to the two tables.
when I run the webservice I can find all the coloumns and entires displayed in WSDL
Then I created a Infopath form and established a main query connection to webservice.
Here I insert the query node EMP_ID and when I try to pull the record with the EMP_ID as the criteria it pulls all the records from the database and not the record which matches the EMP_ID.

I am a beginner in Infopath and C# so I don't know what I'm doing
wrong. However I suspect that I may have to change the select command
for the sqlDataAdapter to pull only that record which matches the
EMP_ID.

It would be grat if someone could help.

Thanks in advance.