I have a secondary datasource that I would like to filter by what is entered in the main datasource.
I want to filter the data coming in from my secondary datasource based on the entry date field.
I have a date field in the secondary data source and main data source, but when i follow the link below and do the following steps
1. Double-click the expression box
2. Click the function button beside the default value field
3. Click Insert Field or Group
4. Expand my secondary data source to the entry date
5. Click the Data Filter button on the bottom left of the Select a Field or Group dialog box
6. Choose the Secondary Data sources enry date field in the first drop-down, equals in the second drop-down, and Select a Field or Group from the third drop-down
7. In the dialog box that pops up, go back to your Main DOM and choose the entry date from the main DOM.
8. Click OK about 8 times.
But i can not get it to show data, even though there are matching dates. If i don't filter data populates - Any help would be greatly appreciated.
I don't
I searched the database, but cannot find an anser to my question. i do see answer similar especially here:
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1947