Hi everybody,

I am looking for a solution for my problem. I have setup a new Infopath form
based on a SQL database connection. I have used the query fields to fill in
the information within the data fields. This works great.

First i am going to explain what i want to do with this form. This form is
based on two SQL database tables. One for Employees and one for the cars
they are driving. I have created two views one for the employee information
and one for the cars. On the employee view you can find all the employee
information based on a query on the employee id. I have used the master
detail functionality because sometimes a manager want to search on the
first- or last name of a employee. This section works 100%.

I have inserted the car information (based on the car table) on the Car
view. When i try to query the database from the employee table based on
employee ID then both sections (employee and car view) are filled in
correctly. However when i try to query based on a first name then i receive
more then one record on the employee view. This is the expected behavior.
However when i switch to the car view then i see all the cars listed below
each other of alle employees based on the query. What i really want that
only the cars are listed based on the selected employee in the details
section.

Is this possible ?? I hope someone can help me out !

Kind regards,

Bart Timmermans