 |
 | 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 / October 2005Copy Dropdown list value to a field in repeating section
I have a Dropdown list (say ddl_SubCategory) which gets the list details from a xml file. I also have a repeating section which uses these dropdown list values in one of the field inside (say txt_SubCategory). Now I want to do the following.... 1. As soon as the user selects value in dropdown list and click the button down below...It filters the repeating section so that only txt_SubCategory matches currently selected ddl_Subcategory) will be shown... 2. if there is no records available for the selected ddl_Subcategory, then it should display one empty repeating section with txt_Subcategory value equals to the selected ddl_Subcategory Can anyone suggest me the best method ....i can send you my working file through email for better understanding... Thanks Thiru Hi Thiru, Welcome back. On your data entry view, your drop down linked to txt_SubCategory needs to be inside your repeating section. Then, to display the "filtered" results (on the same view or on other views), you need: 1. To have a dummy field to store your filter when you click your button below your filtering drop-down. 2. The "filtered" repeating section/table needs to be linked to the field above; that section is just a copy of the one you have on the data entry part of you form + 1 filter). In your current form, you are mixing up data entry part and the display with filters. I just emailed you a small example that will help you. The dummy field is field4. That sample is using some scripting for the button. You may want to look into scripting as it will provide you lot of flexibility. Regards, Franck Dauché > I have a Dropdown list (say ddl_SubCategory) which gets the list details from > a xml file. I also have a repeating section which uses these dropdown list [quoted text clipped - 14 lines] > Thanks > Thiru Franck, In your example, you have shown two repeating sections and a dropdown list box. What I actually trying to achieve is to use just one repeating section and a dropdown list box. And if we choose first option in dropdown list and click the button down below, it should filter the data in the repeating section so that all matching fields (i.e current dropdown value = txt_subcategory value) and also users should be able to add records and in that case, txt_subcategory value should be equal to dropdown value by default. When i am trying to do that, txt_subcategory value keeps changing in all records whenever i change the dropdown list.... Thanks again... Thiru > Hi Thiru, > [quoted text clipped - 40 lines] > > Thanks > > Thiru Thiru, Well, if you want to simulate this. Delete to top repeating section. Right-click on the bottom repeating section, click on Properties and allow user to add and delete sections. Save that newcopy of the form. Try it.....Do you like the behavior? If you don't, which I expect, here is an alterative: - Keep the top table on the Main page as the Data Entry tab. - Put the drop-down on top of the page like you had before and switch View as you did to show the filtered data (with no data entry ability). You will have a total of 2 Views: 1 for Data Entry / 2 for Reporting (Filtered). Does it make sense? Regards, Franck Dauché > Franck, > In your example, you have shown two repeating sections and a dropdown list [quoted text clipped - 57 lines] > > > Thanks > > > Thiru The second option looks great....I will have admin page (main page) in which i will list all records with a link for each record, clicking on it will take us to the detailed record page. Do i get any samples to start working on this? Thanks Thiru > Thiru, > [quoted text clipped - 75 lines] > > > > Thanks > > > > Thiru Yes you will..check you email. Franck Dauché > The second option looks great....I will have admin page (main page) in which > i will list all records with a link for each record, clicking on it will take [quoted text clipped - 82 lines] > > > > > Thanks > > > > > Thiru |
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.