Master-Detail section with detail on another view

[Bart Timmermans \(BPMI\)]

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

 

[S.Y.M. Wong-A-Ton]

Are you using the standard Master/Detail control that comes with InfoPath or
did you create your own Master/Detail functionality as outlined in this
solution:
http://enterprise-solutions.swits.net/infopath/master-detail-across-views.htm
?

In any case, it sounds like you need to add a filter for the data on the car
view. If you're using a repeating section that is bound, you have a "Filter
Data" option. Have you already tried adding filters there?

 

[Bart Timmermans \(BPMI\)]

Hi,

Thank you for your reply. I have used the standard Master/Detail
functionality of Infopath. I have tried to use data filters. I have entered
EmployeeID=EmployeeID where the first EmployeeID is from the car table and
the second employeeID is from the employee table. However it still returns
all the values. This indicates that he will look up the EmployeeID in the
master section of the master/detail functionality. This is the reason why
Infopath returns all the values based on the query. If i enter a first name
(Dan) Infopath will return all the Dan's he can find in the master section
of the master/detail functionality.

I hope someone can find a solution for this problem.

Kind regards,
Bart Timmermans