4 Replies Latest reply: Jul 10, 2015 5:22 AM by Andrew Whitfield RSS

    Suppress records from table based on select fields

    Steve Dillon

      I have a table box loaded with all records from database. What I want to do is use select fields to suppress records from the table that meet those criteria. So instead of isolating criteria that meets the selects, I want to suppress those records that meet the selects and just leave those that don't in the table.

       

      As an example - I have a select field: Region. I want to be able to pick "Midwest" region from that select field and the result is all records associated with "Midwest" region are suppressed from the table. Leaving only those records associated with the unselected regions.

       

      I'm sure someone has accomplished this, so if you could point me in the right direction to previous discussions on this or provide the solution you found, that would be great.

       

      Thank you.