Role & Permissions

sajidhanifkhan

Hi,

How can I make permisisons on field level on a form where I want to show part of the form to the user and full form to an other user? I am using Navision 5 with Sql 2005.

Field level option is appearing on table data permission only but still I need to know how to filter the fields on the form?

Thank for any ideas in advance.

regards
Sajid

garak

Thats so not possible.
Here you can only create your own "Permission" Table where you store the user id, form id and Fieldname and a checkbox if visible allowed.
On every form, where you need this, you must develop the following (and this is a hard work):

OnOpenForm()

if MyFormFieldPermTable.get(UserID,CurrForm.OBJECTID(FALSE),FieldIDOrFieldName) then
  CurrForm.MyFieldOnForm.visible(MyFormFieldPermTable.visible);

Regards and good luck