Two methods will accomplish this. Both involve the use of some kind of "flag" to indicate the status.

This "flag" could either be a single field or could be the result of the data in several fields.

You can use record level validation in Filemaker 5.5 and set the editing validation to only be allowed when the results of the lock status is equal to 1.

(i.e. Flag = 1 or InvoiceStatus <> "Complete")

You can also use an editing layout which is seperate from the browse layout. Then you only allow users to access the editing layout when the lock status is equal to 1. Basically the calcs are the same either way, only the actual implementation is different.

Foodsman,

I emailed you a file that might help with this.

Good Luck.

Once an invoice is compleated, I would like to be able to lock it so it cannot be modified. The ideal would be all invoices done today would lock effective the next day. The main thing I want to do is keep from an accidental change to an order. How would you do this?

I would also want to be able to UNLOCK an invoice if a change was necessary.

Thanks for your help,

Harry

quote:

---

Originally posted by foodsman:

Thanks for getting back to me. I think what I would like to do is lock the record after the invoice is paid. Once a check number is entered the order status field is changes from Invoiced to Paid. How would I "lock the record" once paid?

---

You can use record level validation in Filemaker 5.5 and set the editing validation to only be allowed when Order Status <> "Paid".

You can also use an editing layout which is seperate from the browse layout. Your navigation scripting would either take the user to the browse-only or editing layout depending upon the value in the Order Status field.

What I would like to do is have the order lock once the oder has been paid. Currently, when a check number is entered into the CheckNbr field PAID is automatically entered into the OrderStatus field. It is a this point I would like the entire record to lock.

What is the best way to do it?

Thanks.

Harry