Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2004

Tip: Looking for answers? Try searching our database.

InfoPath Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SK - 13 Jul 2004 21:02 GMT
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
Steve van Dongen [MSFT] - 16 Jul 2004 08:42 GMT
>Hello,
>
[quoted text clipped - 28 lines]
>I appreciate it any help or insight into this, so at
>least I know what approach to take.

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
--
Please post questions to the newsgroup; everyone benefits.
This post is provided "AS IS" with no warranties, and confers no rights
Sample code subject to http://www.microsoft.com/info/cpyright.htm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.