I tried to answer this yesterday, but I got disconnected in the midst of things. I don't know what the problem was.
What you can do, Mike, is add a line right at the beginning of sub query in db.cgi.
Just after
local (%sortby);
add
$in{'status'} = "active";
That line will only allow active records to be viewed by anyone. If you want for those with admin permissions to be able to see closed records, you can use
Code:
unless ($per_admin) {
$in{'status'} = "active";
}
------------------
JPD