Casey_

I want that users see only the objects they have created in a given table. For that I've set custom priviledges for the records in the users' priviledge set such that there is a limited access for viewing, editing and deleting according to the calculation: CreatedBy = Get ( AccountName ) where CreatedBy is a global field populated at startup with the function Get(AccountName). This means that the current user sees only the entries he has created in that table. However, when viewing a list view report on that table the current user sees all the fields he didn't create. These fields have the value: Keeping that priviledge set route, is there a way to have those fields totally hidden, i.e. just having these entries removed rather than showing ?

Ok, now I think I understand. When using a pop-up menu the ID is always stored even if the Table View shows the corresponding name instead. Indeed, having a pop-up menu means that there's a value list that may show the terminal name instead of the ID. This can be checked by populating a field using a pop-up menu, then changing this field to an edit box and going in the Table View: the IDs are now shown instead of the terminal names that were previously coming from the Value List of the pop-up menu. Thanks for your help!

Many thanks for the quick answer and for the demo. I think that your demo will solve my problem. I just need a bit more time to fully understand the demo and to adapt it to my needs. I will post later a follow-up. Finally, for completeness I've attached a minimalistic example that reproduces the problem I have encounted with the change from dropdown list to popup menu. EDIT: following your suggestion of adding a related field, I have found one way round the problem: creating a TO and linking the ManagerID field with the ID field of the TO and adding the related field showing the name. However this is not optimal because it creates yet another TO. TEST_ValueList.zip

Level: Beginner OS: Win 7 X64 (not listed in profile options) Hi everyone. This is my first post and I'm rather new to FM so I apologize in advance if my question is very basic. I'm trying to create a drop-down list with a value list based on IDs and always showing the corresponding name (not the ID). However the ID must be finally stored in the table. To do so, I created a value list with the first field referencing to the ID and the second field referencing to the corresponding name, showing values only from the second field. Back to browse mode, clicking in the field shows indeed the list of names (OK) but once one name is chosen it then shows the ID in the field (not OK). The ID is stored in the table (OK). Trying to find a solution by changing only the control style from drop-down list to pop-up menu, back in browse mode the name (and not the ID) is always displayed (OK) but the name is now stored in the database instead of the ID (not OK) ! My questions: 1) Is there any reason for such a different behaviour between drop-down list and pop-up menu ? 2) How to always display names and store IDs in the table ?