Suppress records from table based on select fields
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.
Re: Suppress records from table based on select fields
Thank you for the reply. I've converted the table to a straight table. Now how could I go about using my select field to suppress records from the table?
For example, I have a select field titled "Region". I want to be able to select "Midwest" from the region select group and have all records associated with the "Midwest" region suppressed from the table.