I have a scenario where individuals need to see a variety of different task is separate table and the data is such that it cannot be co-mingled. As such I am building a dashboard view and would like the user to be able to select a single name from a combo box and have two separate list views change to reflect only the name they selected. Essentially I am looking for the filtered rows functionality with the user only having to work one filter to control both. In the crude example below:
Data Set-A: Data Set-B:
Name ID Number Date Expiring Name ID Number Date Expiring
Bob 1245 12/31/16 Jane 245324 3/13/17
Smith 23235 9/14/16 Randy 2542 7/8/18
Bob 2354 8/15/16 Bob 5435 9/12/16
Jane 232 10/1/16 Randy 34325 11/2/16
If the user selected “Bob” from the combo box, the list views would show:
Data Set-A: Data Set-B:
Name ID Number Date Expiring Name ID Number Date Expiring
Bob 1245 12/31/16 Bob 5435 9/12/16
Bob 2354 8/15/16
Ultimately I have 4 data sets with 68 names. Not all names will show up in all data sets. Any suggestions would be greatly appreciated.