Sorry if this posting is out of left field, but a week or two ago,
someone posted about having a problem locking records after they are
printed. I had responded about setting conditional privileges, but the
real problem was not locking the parent record, but the related child
records in the portal. If I'm repeating a solution already offered, I
apologize.
I was interested since I have a similar situation.... billing
statements that have child "line items." I have a number field that is
a "lock" field, auto entered as a Zero, then when the statements are
printed weekly the number is replaced with a 1, then when monthly
Invoices are created, the number is replaced with a 2.
It was easy enough to set a custom privilege set so that the Statement
records could only be modified if the lockout field = 0. But a user
could still create a new line in the portal. I had put the whole thing
aside until I upgraded to FMPro 10, and there was the solution! With
the new script triggers, I set a script step on entry of any of the
fields in the portal. The script simply checks the content of the
statement lockout field. If it's zero, they go about their business,
but if not, it shows a dialog box to explain that the statement has
been printed or Invoiced, and then exits the portal. I know this
probably could have been accomplished previously with a plugin, but
this is soooo simple.
Hope that helps someone else.
Rick
___________________
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
