https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/68314.aspxMon, 11 Jul 2011 17:35:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:68314Ted Fitch0https://www.infopathdev.com:443/forums/thread/68314.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=68314<p>Hi IT_Girl,</p><p>Have you tried using filtering in InfoPath to do this?&nbsp; You should be able to do this using filtering, perhaps take a look at this article on the Office web site:</p><p><a href="http://office.microsoft.com/en-us/infopath-help/filter-the-data-that-is-displayed-in-a-control-HA010024281.aspx">http://office.microsoft.com/en-us/infopath-help/filter-the-data-that-is-displayed-in-a-control-HA010024281.aspx</a></p><p>Hope that helps</p><p>Ted</p>https://www.infopathdev.com:443/forums/thread/67807.aspxMon, 27 Jun 2011 21:39:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:67807IT_GIRL0https://www.infopathdev.com:443/forums/thread/67807.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=67807<p>I have created an info path form. Thre are&nbsp; 4 fields that are all interrelated. All of those fields are stored in an external Microsoft Access Table. Rather than right a specif if and statement for each item, how can I connect the fields on my infopath form so that they are always tied to eachother?</p><p>Example. Each Job has a unique position code, tied to that position code is the department, job title and status. I have Position as a drop down field on the form. I want the other fields to auto-populate based on what Position is selected.</p>