 |
 | 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 / December 2004Filtering data into repeating table
I have a form with two controls - DocType & Property - and a Access db as Secondary Data Source (SDS) with the fields DocType, Property, Name & Section. I want to create a read-only distribution list from the SDS. I have put a repeating table in the form and populated it with the data from the SDS. How do I filter the data so that only the data that matches DocType & Property is displayed? Or should I use some other control rather than the repeating table? Example: On the form DocType is selected and = Lease; Property is selected and = SCP. The repeating table will display Name and Section only for records whose DocType field = Lease and Property = SCP. Bonus question: Is there a way to grab the displayed names and enter them into the To: field in an Outlook email message if a button is clicked? (Our Outlook will then lookup the corresponding email addresses). hi, assuming that the two controls are just simple text fields: did you try setting the data filter for the repeating table in design mode (on the property page of the repeating table) ? regards em > I have a form with two controls - DocType & Property - and a Access db as > Secondary Data Source (SDS) with the fields DocType, Property, Name & [quoted text clipped - 15 lines] > in an Outlook email message if a button is clicked? (Our Outlook will then > lookup the corresponding email addresses). The filter button is disabled (actually it disappers altogether) when a secondary data source is selected. If I leave the table with the main data and just set the fields within the table to the Secondary Source, the filter just doesn't work. > hi, > assuming that the two controls are just simple text fields: did you try [quoted text clipped - 22 lines] > > in an Outlook email message if a button is clicked? (Our Outlook will then > > lookup the corresponding email addresses). did you figure this out? The filter button is not available for me and I am also using a secondary data source as the bound to the repeating table. All help says update the properties of the repeating table but this is not available. I want to limit what is shown in this table based upon a list box selection. any help is appreciated. > The filter button is disabled (actually it disappers altogether) when a > secondary data source is selected. If I leave the table with the main data [quoted text clipped - 27 lines] > > > in an Outlook email message if a button is clicked? (Our Outlook will then > > > lookup the corresponding email addresses). No I haven't. I did get a response from someone in another forum though. It appears that it can be done with custom coding and this person's company did that sort of work -- I can't swing the cost though. Someone who knows VB might be able to figure it out. > did you figure this out? The filter button is not available for me and I am > also using a secondary data source as the bound to the repeating table. [quoted text clipped - 36 lines] > > > > in an Outlook email message if a button is clicked? (Our Outlook will then > > > > lookup the corresponding email addresses). Filters on secondary data sources are not supported natively... but you can do them. You will need to manually add the filter to the .xsl file. InfoPath will leave your filter alone once its there... you just cannot do it through the InfoPath UI. If you need an example of what a filter looks like, create a sample form with a repeating table and add a filter to it. Then look at the .xsl file to see what InfoPath did. Copy this filter to your secondary data source table and modify the filter to suit your needs. Sorry it doesn't get much easier than that.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com No I haven't. I did get a response from someone in another forum though. It appears that it can be done with custom coding and this person's company did that sort of work -- I can't swing the cost though. Someone who knows VB might be able to figure it out. "ChrisM" wrote: > did you figure this out? The filter button is not available for me and I am > also using a secondary data source as the bound to the repeating table. [quoted text clipped - 42 lines] > > > > in an Outlook email message if a button is clicked? (Our Outlook will then > > > > lookup the corresponding email addresses). |
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.