Rick,
Thanks for your suggestion, yes I've already worked that out but there
are a few problems. Primarily, any related fields on a record that has
been 'locked' using privileges will also restrict any modifications to
that information in the appropriate layouts/tables that hold that data
by the same people locked out of those records. For example if the
record is an invoice and the client's name/address etc are related
fields then the 'client' table that holds those records cannot be
modified to update an address for example.
Tricky but there are limitations whichever way you go. Obviously the
client info could be a lookup which would solve that problem but it
removes the auto updating of client data when the invoice is first
raised, again such as phone numbers/address etc.
Thanks for your thoughts.
Lee
Rick O'Quinn wrote:
Lee,
I'd have to open up FMPro to find the exact right jargon and method,
but right off the top of my head, I'm pretty sure you could do this
via a conditional privilege set. Something like, IF Printed = No, user
group XX has edit privileges. That's may be the best path to look at.
I've got something like that built into our billing system so that
after our account manager has sent out the statements, the staff can't
come back and change an invoice that's already been processed and sent
to the vendor.
Rick
On Apr 2, 2009, at 6:00 PM, FMPRO-L automatic digest system wrote:
Date: Thu, 2 Apr 2009 17:51:46 +1100
From: Lee <[email protected]>
Subject: locking records
Hi,
I think this has come up before. Is there a way of locking a record once
its been printed so it cannot be modified.
I can change the validation of each field to achieve this but it seems a
long winded way of doing it. Currently if a record has been printed (the
word 'printed' is shown on the screen). From that a field validation
calc. is set so that if the word 'printed' is on the record the
'validation' fields cannot be modified.
--
It would be ideal if the word 'printed' is in that field, nothing could
be modified on that record or maybe something in the print script could
be added to achieve the same end.
Lee
___________________
Rick O’Quinn
Photographic Services Coordinator
University of Georgia
Public Affairs
Broadcast, Video & Photographic Services
188 Georgia Center
Athens GA 30602-3603
Work: (706) 542-8085
Fax: (706) 583-0011
[email protected]
http://www.photo.alumni.uga.edu
--
