Why is this so hard - need multiple users to only be able to see their records

[jwnacnud]

Please, I am just looking for how to make something like a Journal database where all the journal entries are stored in the same table but when a user logs in, they can only access the records that they created. Do I need to use a script for this or does record level access work for this. I understand best with an example. Something super simple would work.

Simple table with the following fields:

ID

CreatedBy

Content

[bruceR]

Use privilege sets; see example file attached. You must also remap the "find all records" command to a script that performs a find for "*" in an indexed field that always contains a value; such as record ID. In the attached file the accounts have no passwords, they just use the account name.

AccessDemo.fp7.zip

Edited May 9, 2010 by Guest