InfoPath Dev

 Ok, I found a solution. I created the Main data source from two tables: the table for the Main and the Secondary sources. Then I set a Relationship.  Now everything works perfect as I "have"  all Secondary fields in the Main data source and can set up a correct Filter.  Thanks, Yosif

 By file I mean a table.  The funny thing is that I recreated the test and it is working now. Thanks!!! I do not understand why it did not work earlier. The only difference is that yesterday I connected InfoPath 2007 to Visual Studio 2012. Thanks, it works!

  There are no conditions. There is no real filter, all I am doing - showing a field from a file. There are two fields: the key which I choose and it is showing in the drop-down box and a second field from the same record, which does not show in a text box. I am not sure calculated value will work, I will try. I really need to show a ...

Thanks for the reply!!!  The form is connected to Access Database and I need to attach two of them. The form is simple: I have a drop-down list bound to a CourseName text field in a Workshop table. The values are populated from a secondary data source called TestQuestions In a simple form I would type all the ...

I am trying to design a form. I want to change the text on the screen depending on the users choice from a drop-down box the key field for a record. The fields are not in the Main data source, they are in a separate file - Secondary data source. The drop down works fine, but I can't make the other fields to show in the textboxes. The Rules ...