Is there anybody who can teach me a trick to lock records in FMP7?

Ideally I would need something that allows me to lock the records in a table once the invoice has been sent for that record.

Thank you for your help.

Best regards,

Stefan

This can be done with the built in Access Privileges settings.

In the privilege set for the users, define custom Records access: for the invoice table (and maybe line items), set the Edit access to be defined limited by a calculation, something like Invoice::Status <> "Closed".

Thanks so much. Worked like a charm.

Best regards,

Stefan

I'm doing this exaclty

in the edit part of the privileges, I set limited to when Status ? "Closed"

It isn't working... :S