value lists and privelege sets in IWP

[TDebb8594]

I have a database with about 12 tables. I want to grant access to only 5 tables but the tables contain fields with Valuelists using data from non accessed tables. I have tried allowing access to view and modify the fields containing the data being accessed by the value list but it doesn't work.

For instence, I have a table called "papers" related to 2 other tables, "grants" and "personnel". The papers layout has an author field with a dropdown list containing a value list using the data from the "employee" field on the "personnel" table. The "papers" layout also has a field called "related project" which uses a dropdown list that contains a value list using data from "project name" field on the "grants" table.

Users have acces to the "papers table" but cannot have access to the "Personnel" table or the "Grants" table.

I have set the value list privelege set to both view and modify but I still can't seem to get access to the value lists from IWP.