Access and look ups

[Slobey]

Hi,

I was wondering if I deny a user access to a pricing table, will lookups still work? I had a user enter a unit code and the price and description fields did not populate. I am not sure if this is due to the access limitations or not.

Thanks

[Brian C]

When you start denying access to specific fields/tables - access rights will override anything you have in a script or a lookup. This is done in case someone is attempting to "hack" the database table using a table of their own in an attempt to navigate past interface protections.

Your best bet is to instead allow read-only access to the table. You could then restrict access to specific layouts which would allow the user to access the data, but never do anything in that table directly.