Archive and Delete
I am running Filemaker pro advanced. osx.. I am building a database to keep track of patients while they are in the hospital, I would like to have an active list that shows only patient that are admitted. When they are discharged I would want to delete them from the active list and archive them to keep track of number of patients adm ect... I am trying either to have a checkbox that says "Discharged" and when checked run a script that deletes and archives, or a button that does something similar.
I would appreciate any help you can give me