Locking Records in FMP7

[Stefan Huyghe]

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

[Ender]

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".

[Stefan Huyghe]

Thanks so much. Worked like a charm.

Best regards,

Stefan

[skumancer]

I'm doing this exaclty

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

It isn't working... :S