Repeating Section issue

[Jeff]

I am trying to create a form which is based on an Access
Database. The use will fill out the form and then submitt
the data to the database. I want to add a Repeating
section or table under a field called Client ID and have
the fields in the repeating section be tied to the Client
ID. I want the client ID to display only once on the form
no matter how many times I add additional repeating
sections. When I try this and submitt to the database
only the first row in database contains the Client ID.
The rest of the rows which came from adding additional
repeating sections aren't tied to the client ID. If I use
a master/detail relationship I can get this to work but
when I add a repeating section for more detail about the
Client ID additional Client ID fields also appear in the
Master section. I want only One Client ID field to
display no matter how many detail repeating sections I
have and still have it passed to the database tied to the
Client ID field. I hope this makes sense and I am really
stuck on this one. Thanks.--Jeff

 

[Jerry Thomas [MSFT]]

The way I have handled this (and I admit it isn't elegant), is to create a
seperate xml file with only 1 field. Add that as a second data source and
add that one field above your repeating table. Link the UserID in the table
to that field. Whatever is put into that field gets copied to your Repeating
Section.

--
Jerry Thomas[MSFT]
<[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

 

[Jeff]

It does sound correct, and I am a Infopath Newbie here,
however when I select to insert a repeating sections a
new Client ID field is displayed under the origional in
the "Master" section. Hear is how it looks. On the form
you select the Client ID from a drop down menu at the top
of the form (This is set a the "Master" Section) Below
this is a repeating section ("detail" section) with all
of the detail about the Client ID. If I were to add
another repeating section of detail a new Cleint ID drop-
down box will appear under the origional in the Master
Section. It contains the same Client ID value as the
origional but I only want the use to see this field once
no matter how many repeating sections of detail there
are. So how would I hide this in the view when the user
has to see it once to make Client ID selection. Thanks
you very much of the reply. --Jeff

-----Original Message-----
If I'm understanding your scenario correctly, what you

need to do is make sure that each row in the repeating
table has a Client ID field in it. That ID needs to be
auto-populated with *THE* Client ID every time a row is
inserted. Visually, you just remove that field from the
table in the view -- that way the user doesn't see it on
each row, but it's still there for the database.

Does this sound like what you were needing?

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



"Jeff" <[email protected]> wrote in

message news:[email protected]...

 

[Jeff]

Greg,
Thank you very much and you got it right. I tried this
and it worked just like I needed. I am slowly starting to
figure this application out and I thank you very much for
helping me out.--Jeff

-----Original Message-----
Jeff,

I think I'm following now. It sounds like a structural

issue, and with your current layout, it may be difficult
to achieve what you want. The reason is that if you hide
the repeated Client IDs in your master, you won't be able
to get access to each of your detail sections.

What you need is a single drop-down list with a single

section for that drop-down and then inside that single
section, you need the repeating table/section for the
details. A Master/Detail control may not be the correct
choice for you here. More likely you would want something
like a single drop-down list and a repeating section
which is FILTERed on the value of that list so that it
only shows 1 section. Then inside that section you would
want a repeating table/section for the details so that
you can add/delete information for that Client ID.

Hopefully that made sense.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



"Jeff" <[email protected]> wrote in

message news:[email protected]...

It does sound correct, and I am a Infopath Newbie here,

however when I select to insert a repeating sections a
new Client ID field is displayed under the origional in
the "Master" section. Hear is how it looks. On the form
you select the Client ID from a drop down menu at the top
of the form (This is set a the "Master" Section) Below
this is a repeating section ("detail" section) with all
of the detail about the Client ID. If I were to add
another repeating section of detail a new Cleint ID drop-
down box will appear under the origional in the Master
Section. It contains the same Client ID value as the
origional but I only want the use to see this field once
no matter how many repeating sections of detail there
are. So how would I hide this in the view when the user
has to see it once to make Client ID selection. Thanks
you very much of the reply. --Jeff

-----Original Message-----
If I'm understanding your scenario correctly, what you

need to do is make sure that each row in the repeating
table has a Client ID field in it. That ID needs to be
auto-populated with *THE* Client ID every time a row is
inserted. Visually, you just remove that field from the
table in the view -- that way the user doesn't see it on
each row, but it's still there for the database.

Does this sound like what you were needing?

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com


"Jeff" <[email protected]> wrote in

message news:[email protected]...

I am trying to create a form which is based on an Access

Database. The use will fill out the form and then submitt
the data to the database. I want to add a Repeating
section or table under a field called Client ID and have
the fields in the repeating section be tied to the Client
ID. I want the client ID to display only once on the form
no matter how many times I add additional repeating
sections. When I try this and submitt to the database
only the first row in database contains the Client ID.
The rest of the rows which came from adding additional
repeating sections aren't tied to the client ID. If I use
a master/detail relationship I can get this to work but
when I add a repeating section for more detail about the
Client ID additional Client ID fields also appear in the
Master section. I want only One Client ID field to
display no matter how many detail repeating sections I
have and still have it passed to the database tied to the
Client ID field. I hope this makes sense and I am really
stuck on this one. Thanks.--Jeff.