 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / September 2004Repeating Section issue
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 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?  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com 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 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? > [quoted text clipped - 18 lines] >stuck on this one. Thanks.--Jeff >. 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. SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com 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? SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com "Jeff" <anonymous@discussions.microsoft.com> wrote in message news:48e101c49fea$0e2b2a10$a401280a@phx.gbl... 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. 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. > >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? message news:48e101c49fea$0e2b2a10$a401280a@phx.gbl... >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. >. 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. SignatureJerry Thomas[MSFT] <Jerryth@online.microsoft.com> 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. > I am trying to create a form which is based on an Access > Database. The use will fill out the form and then submitt [quoted text clipped - 15 lines] > Client ID field. I hope this makes sense and I am really > stuck on this one. Thanks.--Jeff |
Reply to this Message |
 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.