Hiding fields from view based on account values.

[Dave C from CPWG]

I'd like to create a layout for a file so that when particular (restricted) accounts access the layout, some of the fields are hidden from view and the remaining are view only.

I'm new at FileMaker.

I assumed the way to do this is as follows...

1. Define a privilege set.

2. Assign the privilege set to the restricted accounts.

3. The privilege set is defined as follows....

-- Open the 'Edit Privilege Set' dialog.

-- On the 'Data Access and Design' panel, select 'Custom privileges...' for the' Records:' field.

-- On the 'Custom Record Privileges' dialog, set 'View' = yes, 'Edit' = no, 'Create' = no, 'Delete' = no, 'Field Access' = 'limited...'

-- On the 'Custom Field Privileges' dialog set some of the field privileges to 'view only', and the remaining to 'no access'.

Whe I open the file from one of the restricted accounts, I hoped to see the layout with some of the fields hidden from view. Instead, a 'No Access' error message is displayed instead of the layout.

Am I doing something wrong? Is there a way to accomplish what I want?

Thanks.

[Søren Dyhr]

I hoped to see the layout with some of the fields hidden from view.

If thats what you're after should you use the visibility trick with:

http://www.filemaker.com/help/FunctionsRef-250.html

The link to the visibility trick could be found here:

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

--sd