I have created four SharePoint list I would just like help getting through the first part in the first list, "Facilities" there is a list of facilities, with columns that show the available process for that facility, you can only select one. Once you do this I would like the second drop down list to only show a list of processes that can go on at the facilities. This will continue till I get to list four which will show the tools I need to do the investigation. So I've created my infopath form and created the data connection that pull in my list of facilities. How do I get my second drop down in infopath to only show the process that work with that facility.
Example: From my drop down I select "Bulk Loading Facility" I should only get a four item drop down menu for process, even though it is selecting from 17 processes.