Skip to Content
0
Former Member
Aug 02, 2016 at 12:09 AM

Control Multiple List Views(filtered rows) With A Single Selector(combo box)

26 Views

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.