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 / June 2006

Tip: Looking for answers? Try searching our database.

Parent - Child Structure

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mailother2@gmail.com - 26 Jun 2006 22:07 GMT
I have a form that has the main datasource as an Access database.  The
database contains a parent and two child tables.  The relationship is
one (parent) to many (either child).  The parent table contains
overview information and the child tables are contact and revision
information in repeating InfoPath tables.

Problem: If I fill out the parent table information but don't fill out
any child information (not required), InfoPath is automatically adding
a row to the child tables in Access.  The rows contain the key
information from the parent and all other fields are blank.  Even if I
blank out the key fields in the child table, InfoPath autofills the
keys when I submit.

Is there a way to get around this?  I only want to have child rows if
information was actually added to the repeating table.  Otherwise, I
have a bunch of blank rows (with key info) in my database.

Thanks,

Chip
Anuma - 28 Jun 2006 12:24 GMT
Hi,
Please look at this link.
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2707

Thanks
Signature

Anuma
http://www.autonomysystems.com

> I have a form that has the main datasource as an Access database.  The
> database contains a parent and two child tables.  The relationship is
[quoted text clipped - 16 lines]
>
> Chip
 
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.