Jennifer, In my vertical applications I use the technique similar to the one Karen described. In my case, the business owner is able to control access down to the sub-menu level for every employee. The owners really like the feature because it is so easy to use and they can temporarily give access to a menu item to someone for a special project. In the background, it is all controlled with the property commands.
If you, or anyone else, would like to see the process in operation and discuss the underlying code, let me know and I will setup a Webinar. It is not complicated and it is easy to implement. John From: [email protected] [mailto:[email protected]] On Behalf Of Roberts, Jennifer Sent: Friday, February 25, 2011 2:24 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Trigger or Rule or something else? Hello, I have a form with a scrolling region displaying items listed by department. I want the users to be able to see all the items but only approve/edit those items that are listed with their department number. I have the security set up so that the application will know who the user is and their department - but how do I prevent them from approving or updating items that aren't in their department? Should I use a before update trigger or a rule, or would there be a better way to handle this? Thank you, Jennifer Roberts Ohio Masonic Home This electronic message contains information from The Ohio Masonic Home, its operating subsidiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected] , for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute or otherwise use this transmission or its contents. If you have received this transmission in error, please notify The Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
