Hello.

I have to build a prototyp for my diploma and need some impulses. Time is
getting close.

I need  a tool for inserting data from workstations, that are not connected
with the SQL database. There are some tables, that I want to convert to XML
files  and then bind as secondary datasource and one table for the output.
All the converting, ex- and import I can handle in the main-programm (it’s
irrelevant) so the client gets only the infopath template including the
sourcefiles and sends back his form.xml.

Now my problem… the outputtable originally has a employeeID as foreign and  
wage-typeID + day  as primary keys. Each employee can have many wage types,
the possible employeeID’s come from a secondary datasource.

In the later form the User should select a employee from a combolist and
then insert his data in a repeating table. When he selects another employee,
the form must refresh with the entries corresponding to the new employee or
set blank if there are none.
Is there a way to force infopath to such a functionality?
How I have to design the primary datasource (XML) for such a structure?

Thanks,

Paul Degenkolbe