When you create a UDF and link it to a table, the end-user is always presented with a Define New option at the bottom of the resulting list allowing the end-user to add rows to the linked table.
Is it possible to prevent the Define New option from being displayed?
You cannot get rid of this value but you can restrict adding new or changing existing values. You can create an additional authorisation to make your UDT read-only and assign this authorisation to a user. Then if a user presses "Define new" option the form comes disabled and the user can't change anything. Also you can use Transaction Notification but then you will need to hardcode user codes you want to prevent these changes from, so I don't think it's the best solution.
No he will see define new option you deploy a transaction notification even he see define new but he will not be able to add new values in that table. Or save values in seperate UDT and deploy a FMS in UDF to fetch from UDT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.