change all based on "active"

[jbaldree]

I have created a student information system using appgini. I need some advanced customization work (and willing to pay for it ). In my 'students' database, I have a 'status' field with the choices of 'none' 'active' 'inactive'

I need every database to filter based on whether the student is 'active' or 'inactive'

I know I can go to the filter and choose 'active" but I only want the 'active' students to show in all databases.

The 'status' field is only in the student table.