DW
|
| Posted: 01/09/2004, 8:51 AM |
|
Howdy,
I'm trying to brainstorm the logic on how to allow multiple users to list and to have edit access to only certain records.
I'd like to have multiple users designated to update specific records that they have been given rights to update. For instance Joe and Bob can both update the records describing labs that they're responsible for. But Joe might also be responsible for a lab that Bob isn't, so I don't want it to show up on Bob's listing or to allow Bob to edit it.
Any clues on a good strategy?
Thanks,
DW
|
|
|
 |
Edd
Posts: 547
|
| Posted: 01/09/2004, 3:41 PM |
|
Just create a sub table that has just the ID of each user and the ID of the record that they are to update.
When you create a "job" you then need to assign it to a user. If you don't have too many users then use the Checkbox List objects.
In the Select of the List of tasks inner join to the sub table based upon the user's ID so they only see the tasks they are assigned.
Couple of variations - 1. You might put people into usergroups as your subtable as link people to usergroups to tasks.
2. You might put people into specialties so you can assign a based upon a requirement and then link requirements to specialties.
Good Luck
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
|
