Interactive Form

[john mcmichael]

I am trying to create a form using Infopath 2007 that is interactive. The
form should start with a field that lets people choose a department name once
selected, I would like the form to update to show jobs within that
department. The user will then choose a specific job and the form should
update again to show the responsibilities for the job. Is this possible? I
have an Access 2007 DB that has tables for Deparments, Jobs and
Responsibilities already.

Thanks in adavance for any advice you can throw my way. Have a great day.

 

[S.Y.M. Wong-A-Ton]

You need to look into using a solution with cascading lists. Try this link
http://www.infopathdev.com/search/SearchResults.aspx?q=Cascading+List&u=2105

It should be relative easy to set up with the tables you already have. What
you can do is create a receive data connection for each table and bind a
drop-down or list box to each one of the data connections *and* use filters
to filter each list based on a selection in the previous list.