https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/96382.aspxMon, 10 Mar 2014 19:35:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96382henry2960https://www.infopathdev.com:443/forums/thread/96382.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=96382<p>&nbsp;I am using InfoPath to connect to a Microsoft Access database and I&#39;m running into two&nbsp;issues in how I want to setup my parent-child table relationships.</p><p>1.&nbsp; My primary data table has 1 record per location and I want to be able to return results based on the data in a 2nd child table.&nbsp; The second child table has 1 row per location but not all locations are included.&nbsp; When I run the query it returns all results from the parent table; basically ignoring the criteria I&#39;ve entered.&nbsp; When I use a 3rd table that has the same number of records as the primary table it works fine.</p><p>&nbsp;2.&nbsp; I want to be able to e-mail certain people when the form is submitted based on the people assigned to that location using a rule.&nbsp; Each record in the parent table has the person&#39;s ID, but when I join to a table with their e-mail address based on that ID it says there is a&nbsp;many to 1&nbsp;relationship between the parent and child table and therefore, I can no longer submit the form.&nbsp;&nbsp; However, it is actually a 1 to many relationship. </p><p>&nbsp;Thanks for any help you can provide</p>