I have 2 tables linked via a common ID value.
Table 1 has a set of records to be displayed in a table.
Table 2 has a number of related True/False attribute fields related to Table 1.
I need to filter the Table 1 information with a series of True/False buttons (Chiclet slicer with 1 button per T/F attribute) coresponding to each of the True/False attributes in Table 2.
I would like to default to all records (all Chiclets = false) - displaying all rows.
Selecting any of the Chiclets (True) enables filtering to rows containing a true value for the attribute associated with the Chiclet attribute. Selecting multiple Chiclets applies a logical "AND" to the filter, displaying any rows containing all rows with true attribute values.
I am having trouble configuring the Chiclet Slicer associating multiple fields representing a boolean toggle.
I am also open to other filtering options that do not consume a lot of screen area.
Thanks,
Ross
