Customer experience | Sales, Customer Insights,...

Lookup Field Security on Forms

(0) Share

Report

Posted on by anavrin

Hello,

I have a few lookup fields on one of my forms and I am running into an issue.

when the form loads it not only checks users privileges for the current record but also the privilege's for any related table when the lookup field appears on the form.

It does not prevent the user from reading the field but throws a vague permissions error.

I know the tables causing the error but do not want these users to have the security to access these tables directly.

I can not remove the fields from the form as they are referenced by for asset validation in MS script.

any thoughts?

All responses (3)

Answers (0)

Suggested answer

Bipin D365 28,981 Moderator on at

Like (0)

Report

RE: Lookup Field Security on Forms

Hi,

Why don't you create your own custom form and add field which are required for your Business instead of using OOB form.
anavrin 40 on at

Like (0)

Report

RE: Lookup Field Security on Forms

I tried to hide the fields on the forms using the form editor and still had the same issue

would hiding it with JavaScript make a difference?

I would think it would not because I would expect the Microsoft event handler to run first

*Edit*

How would I go about suppressing the Microsoft error message?
Suggested answer

RodRodriguez on at

Like (0)

Report

RE: Lookup Field Security on Forms

Howdy,

You could hide the fields using JavaScript. You could put in a check to see if that access is denied message will show up, if so, then hide the fields (they will still be on the form but the user won't see them) and then suppress the error message.