Hello everybody. Please help me. I have my database invoice. All I want to do is: if the invoices were entered yesterday or any past dates, specific record will be automatically locked and nobody can do the editing today. Please send me a simple sample of the file. Thank you in advance.

A way could be a modification of this approach:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000604

--sd

I am assuming that you have some tight navigation in place.

Have a field, creation date, that is auto entering the invoice creation date. The create a calculated field, unstored, that returns a 1 if get current date = Creation Date and 0 otherwise.

Have two separate layouts for the invoice, one that allows editing and one where all of the fields are locked down.

When navigating to an invoice, if the calculated field =1 go to the editing layout otherwise go to the locked layout.

There are other ways to do this, but this works and it is easy to grasp. But, your navigation has to be locked down for them not to by-pass it.

HTH

Dave McQueen

Anything that works on the layout level is not truly secure and can be by-passed even by a relatively unsophisticated user. The proper way to do this is through Accounts and Privileges.

Note:

Make sure the CreationDate field is set to prohibit modification, and that you compare it to the host's timestamp, rather than the user's computer time.

Edited April 6, 200916 yr by Guest