InfoPath Dev

 I am using info path 2003 and MS access 2003.

In my data base I have two tables which has 1..m (one to many) relation ship. I want to query results from many table when user enter the selection. I wrote a query in the access database. I want to add that query as a secondary data source to the info path . When user select the query value from Drop down I need fetch values related to the search criteria. How can I add that query as a secondary data source to the info path? Thanks

I'm afraid I'm not super familiar with Access -- but can you create a view based off your query? You can select a view as a secondary data source in InfoPath.

But can't you just relate the tables in your data connection? So, create a secondary data connection to Access, select your main table, then click the 'add table' button in the data connection wizard and define the relationship between the tables....