Log in
Hot & Trending on FMT

The FileMaker Get(RecordAccess) Function

FMP Version: FileMaker 7 and higher
Returns A Number Result

You can define a privilege set to have precise control over what a user can see or do on a record by record basis. For example, you could create a privilege set for sales people to only be able to access records they created. Your privilege set options for record level access are

Create, edit and delete in all tables
Create edit in all tables
View only in all tables
All no access
Custom privileges

The Get(RecordAccess) function will return a number that corresponds to the current users access to the current record in the foreground window. It can be used to alert a user of a restriction or be used as a method to branch a currently running script. The numbers returned from the Get(RecordAccess) functions and their meaning are ...

0 ( zero ) - no access to view or edit the current record

1 - view access to the current record

2 - edit access to the current record

This function is only concerned with the record level setting in the privilege set and does not look at layout access. It is possible to have record access but not layout access ( or vice versa ). In a case like this, you would also want to use the Get(LayoutAccess) function to determine true access for the current record, on the current layout and in the foreground window.

Dwayne Wright

Dwayne Wright is quite simply put one of favorite authors. Dwanye has been around with us since the days of AOL. No matter what FileMaker subject you are looking for Dwayne has wriiten something on it.

Be sure and visit his blog listed below.

Website: www.dwaynewright.com/