Dropdown list based on a selected item from another dropdown box

[Meg]

Hi, I have a InfoPath form that has a Training Area ID and Training Area Name
and Training Subject ID and Training Subject name (drop down lists) On my
Data Entry form, when I select a Training Area Name, and then go to select a
Training Subject Name (that list only shows the Subjects for that particular
Area -- which is what I want.

However, I also have another form that is the Search and Edit Form and the
purpose of this is that I have a button to Query by Employee name all of
their training (which it bring back a form for each Training Area and Subject
for that person. But I want that person to be able to edit the data in those
forms and save it back to the database (which is in Access) The form is
exactly like the Data Entry Form and I filtered the info just like in the
data entry form. However when I look at the drop down box for the Subjects,
everything is listed not just for that Training Area.

Do you have any ideas as to what I can do? I am desparate. I think I have
tried everything.

Thanks,

MEG

 

[Clay Fox]

Hi Meg.

You are refering to a "Cascading Dropdown". If you search with this term on
http://www.infopathdev.com you will see multiple examples.
Essentially you filter your source list by the preceding dropdown value.

 

[Meg]

Thanks Clay,

I went and looked at the site and searched for cascading dropdowns, but I am
not sure I understand.

I filtered the data on the drop down in the Data Entry Form and it works
fine there, I have that same filter on the Search and Edit form (which is a
dupicate of the Data Entry Form) The problem lies where I push my query
button that populates all of the Completed training in a separate Search and
Edit form and I want to change the Training Subject but I want it to show me
only the Training Subjects that are associated with the training area. Does
all this make since? I am new to infopath but have done several things with
it just by playing around with it. I just can't get this to work.

thanks,

MEG