I am making a mouse database for my research lab. I want to write a script to omit the records of all the dead mice so we don't constantly have to scroll through them. Right now I have a field called status with a drop down box to choose dead or alive. If the status = dead I want the records to be omitted in the list view.
I tried to set up a trigger script so that as soon as the page is accessed the records are omitted, but it doesn't work.
I am new to FileMaker and still not really sure how everything works.