InfoPath Dev

I have created an info path form. Thre are  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?

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.

Hi IT_Girl,

Have you tried using filtering in InfoPath to do this?  You should be able to do this using filtering, perhaps take a look at this article on the Office web site:

http://office.microsoft.com/en-us/infopath-help/filter-the-data-that-is-displayed-in-a-control-HA010024281.aspx

Hope that helps

Ted