InfoPath Forms

S

SK

Hello,

I've been trying to learn infoPath on my own with any
free information I can my hands on, I've also looked into
some books, but can't seem to find an answer to my
specific situation.

To give you a complete idea, I'm trying to create a
rather simple input form for people to fill out that is
connected to a SQL Server database. There is only one
group with fields.
Now I want a non-repeating section on the form that
contains the person's name and date, but also on the
form, I need a repeating table of the different jobs done
(and other details) by that person which would be
inserted into different records.

So, I only need certain fields to be repeated and added.
But it won't allow it or when I use the preview and add
to the table, everything on the form will be duplicated.

I'm only working with one data source or file - free
table.

How can I create non-repeating fields for some of the
data since when I connect to the database, it'll decide
by itself whether it's repeating or not.

Or how can I change the XML code behind it?

I appreciate it any help or insight into this, so at
least I know what approach to take.

Thanks,
SK
 
S

Steve van Dongen [MSFT]

SK said:
Hello,

I've been trying to learn infoPath on my own with any
free information I can my hands on, I've also looked into
some books, but can't seem to find an answer to my
specific situation.

To give you a complete idea, I'm trying to create a
rather simple input form for people to fill out that is
connected to a SQL Server database. There is only one
group with fields.
Now I want a non-repeating section on the form that
contains the person's name and date, but also on the
form, I need a repeating table of the different jobs done
(and other details) by that person which would be
inserted into different records.

So, I only need certain fields to be repeated and added.
But it won't allow it or when I use the preview and add
to the table, everything on the form will be duplicated.

I'm only working with one data source or file - free
table.

How can I create non-repeating fields for some of the
data since when I connect to the database, it'll decide
by itself whether it's repeating or not.

Or how can I change the XML code behind it?

I appreciate it any help or insight into this, so at
least I know what approach to take.
Click to expand...

All data from a database is repeating. Design your form with
repeating sections/tables; the WHERE condition in your SQL query
should select only the data you want.

Regards,
Steve
 
Top