Is there a way to make entries so that only the person who made them can alter them? I have a problem with people changing appointments others have entered and would like to know if there is a way to prevent them from doing it.

Thanks

(Running on Filemaker 6)

ShelbyM wrote:Is there a way to make entries so that only the person who made them can alter them? I have a problem with people changing appointments others have entered and would like to know if there is a way to prevent them from doing it.

Thanks

(Running on Filemaker 6)

Sure there is. The trick is really in knowing who created the record, and who is modifying it. There are three basic approaches:

a) You can give each user their own Group in FileMaker's access privileges and use patterncount(status(currentgroups)) to find out who is making/changing a reord;

b) You can build a log-in system in FileMaker so you store the FileMaker ID of the logged in user;

c) Or you can use Status (CurrentUserName) to get the user's machine/network name.

In any of these approaches you'll add a new field to the Appointments file to auto enter your value for who created the appointment. You'll then use FileMaker's built in access privileges to select "Limited" rights to Edit records. These are known as record-level privileges and if you search FileMaker's built in help for "Record Level" you'll actually find an example using option "c" above.

Hope that helps,

John