Ive seen some creative ideas in posts on how to regulate which users can delete records. However, haven't seen much in the way of selecting users who can add a record.
I want to avoid using user roles for this, as I want to be able to have a handful of users be able to set this permission. ie - perhaps they have a checkbox on our employee table that says -User has add rights for Table X.
Then somehow use that checkbox field to allow that user to add a record in another table? I cant think of a way to accomplish this. Are there any tricks?
------------------------------
Mike Tamoush
------------------------------