S
sebastian.bettels
Hi,
I'm fearly new to InfoPath and have following problem:
I'm to create a form that shows employs projects and how much time
they spend on it(startTime, endTime) now I need a field that shows the
duation of the project (endTime-startTime) now since I have no clue
about jscript I created a secondary data source baste on an SQL-Query
which only has projectedID ,startTime, endTime and a field Duration
which is calculated based on the SQL-Server Tablel which I use in my
primary data sorce. Now I have the information I need(duration) but my
problem now is to schow this in a repeating table I either get no
information or all durations on every project(more than 6000 entrys)
but I only want to see the duration on the projects that the query on
the primary date sorce returned(i.e.
projectIDprimary=projectIDsecondary) but still I get all 6000 entrys.
Now I hope you can help me solve my problem.
Oh, all the projects that were returnd by the quere are shown in a
repeating table incase that is importand.
I'm very thankful for any help
I'm fearly new to InfoPath and have following problem:
I'm to create a form that shows employs projects and how much time
they spend on it(startTime, endTime) now I need a field that shows the
duation of the project (endTime-startTime) now since I have no clue
about jscript I created a secondary data source baste on an SQL-Query
which only has projectedID ,startTime, endTime and a field Duration
which is calculated based on the SQL-Server Tablel which I use in my
primary data sorce. Now I have the information I need(duration) but my
problem now is to schow this in a repeating table I either get no
information or all durations on every project(more than 6000 entrys)
but I only want to see the duration on the projects that the query on
the primary date sorce returned(i.e.
projectIDprimary=projectIDsecondary) but still I get all 6000 entrys.
Now I hope you can help me solve my problem.
Oh, all the projects that were returnd by the quere are shown in a
repeating table incase that is importand.
I'm very thankful for any help