Our purchase receipt records are locked against user edits once the status in a field changes to "printed" to indicate that a copy has been printed and handed to a customer. We use record level access control via manage security to do that.
Status ≠ "Printed"
as the "lock expression".
See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a description of how to set this up.
this worked great thanks. have come a long way with filemaker knowledge but still learning. thanks again