Use of a trigger...? is this areasonable?

["Booth Martin" <booth@xxxxxxxxxxxx>]

I've just been handed a problem and first blush tells me that a trigger is
the answer, but I sure would like to hear comments from people on the list
that have already dealt with this sort of problem.

Here's the deal:  our name and address file has a field in their for FERPA.
If its marked then the name can not be listed or generally distributed
without that person's written permission.   This has worked fine for years
when we only accessed the information with our RPG programs.

Now though we have users with Query and other methods of accessing the file,
and these users just ignore the FERPA field.  The results are labelled
Trouble waitng to happen".

What ways would you folks offer as ways to prevent access to that record if
FERPA is chosen?  (I'm thinking this is a question all of us are facing
lately)



--------------------------------------------
Booth Martin
MartinB@Goddard.edu
802-454-8315 x235
--------------------------------------------