Don't know if this is the right location but i tought it was the most suitable i could find.

Well, i am wondering if there is a way to set "locks" on records? I've worked with forexample MS Sql Server where you can set read and commit locking. The problem is that i have a multi-user solution and it turns out that two user can infact change the same value in a record. Which can lead to falty data if the change it at the same time. I have however noticed that FM locks a field sometimes but have not been able to figure out when that is.

Is there a way to secure a records so that as soon as a user enters a field on one layout, no one else can change that record?

Thanks for reading.

In FM when one user is editing record and other user want to change this record he get message as:

"Alex is modifing this record"

s there a way to secure a records so that as soon as a user enters a field on one layout, no one else can change that record?

Yes issue a scripted Open Record/Request command, placing the cursor in a field isn't enough. Another way is to use Insert(calculated result) in a field, such as setting it's own value.

--sd

Edited August 22, 200520 yr by Guest

Am I missing something here.

I always believed (prior to 7) that if someone was in a field then all other users are locked out from editing that record. Has this changed in 7?

Phil

Yes it has, read from page 74 and onwards, in this:

http://www.filemaker.com/downloads/pdf/techbrief_fm7_foundations.pdf

--sd

Thank you Soren

Phil

I have only just got around to reading that tech breifing but it was invaluable in helping me understand opening and committing records- thanks again Soren

Phil