End User access

[mlewi1]

I am setting up a training database for my department. I need for employees to be able to log in and look at their information without being able to view others' information. I want them to be able to view their training records without being able to edit them, but I do want them to be able to edit the demographic info.

Any help would be greatly appreciated.

[John Mark Osborne]

When you setup a Privilege Set, there is an option under the Records popup menu for Custom Privileges. In the resulting dialog, you can setup on a table by table basis whether you want people to view, edit or delete by calculation. When you popup the menu under these options, you will see a choice called Limited. The resulting dialog will be a calculation dialog where you can insert any formula to limit whether someone can see the record or not. My suggestion is to couple the calculation with an auto-enter of the Account Name. In other words, each record will contain the Account Name of the person who created the record. You can compare this field with the current account name to determine if someone can view, edit or delete the record. For example, your formula might look like this:

MYTABLE::account_name_create = Get(AccountName)