Repeating Text

[learningaccess]

I am having trouble with repeating sections in a form that I'm
building in infopath. The data in the form is stored in Access. The
basic idea is that the contact information is first and then the
reservation information is next - the relationship is one-to-many.

I want some of the repeating sections to show automatically, but the
only repeating sections that show automatically are the ones that
contain the contact information. The ones that contain the reservation
information all get hidden when I run my query for the contact
information. All that will show is the "insert item text."

Any help would be much appreciated. I just want the repeating groups
to always show on the form without having to be inserted.

Thanks!

KD

 

[Paresh]

I am having trouble with repeating sections in a form that I'm
building in infopath. The data in the form is stored in Access. The
basic idea is that the contact information is first and then the
reservation information is next - the relationship is one-to-many.

I want some of the repeating sections to show automatically, but the
only repeating sections that show automatically are the ones that
contain the contact information. The ones that contain the reservation
information all get hidden when I run my query for the contact
information. All that will show is the "insert item text."

Any help would be much appreciated. I just want the repeating groups
to always show on the form without having to be inserted.

Thanks!

KD

Hi,

If there are multiple reservation records for one contact information
record, then in case of InfoPath 2007, you can write a web service
dataconnection that accepts a contact information record (maybe
contactId or a parameter) and returns the desired reservation records
for this contact information record.
You need to then bind the repeating section to this returned set of
records.

Hope this helps. Do let me know if you need any further information.

Thanks,
Paresh

 

[Clay Fox]

Hey KD.

Start a new template and select Database type.
When you connect to your tables make sure you select your parent table
first, which should be contacts, then select add table and add your
reservations table. If the relationships are keyed properly then InfoPath
will display them and allow both query and submit.

Then I would start with the default layout and drag all of the query fields
into the upper section and the data fields into the lower.

Preview and enter one contact ID and see how the data is returned. Should
show the contact data and nested will be any related reservations.
I am not sure from your desription if the problem is with adding the data in
the data connection or displaying it properly in the view. Typically I would
add a repeating section for the contact and then inside of that add a
repeating table for the reservation.

You can remove the insert if that is not appropriate in the section
properties.

I would start small and play with things until you get used to how it works.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com