Using Multiple Lists Together
List filtering allows you to limit your selections on a given list based on the choice of previously entered data. For example, say you have a list of employees from different departments or locations. I don't want to search for all of my employees at all of my sites simultaneously. This is where list filtering will help. Using list filtering, I can ask what location you are at. Once this location has been selected, it will filter out the employees that are not associated with that given location.
Creating Your Lists
You will need two separate lists to be able to filter correctly. The first list will include the three locations you can choose from, and the second list will consist of the employees.
(List 1 - Locations)
(List 2 - Employees)
After you have created two lists, you will need to link them together by using a Filter Key. Filter keys are unique tags that will associate the two points of data with each other. This will label the employees based on their location.
Next on the employee list, assign them the corresponding value that associates them with the location they belong to. Open your list and click on the Advanced button to add the filter key or corresponding location.
The last step to link these fields together is to copy and paste the field key from the locations list and past it into the field filter key box of the employee list.
When selecting the location from the drop down menu, only the employees that belong to that location will be able to be selected.