Interactive Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john mcmichael - 14 Sep 2007 16:02 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 16 Sep 2007 02:24 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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
[quoted text clipped - 5 lines]
>
> Thanks in adavance for any advice you can throw my way. Have a great day.

Reply to this Message