Tom
|
| Posted: 06/16/2003, 3:02 PM |
|
How do I created custom pages which isnt based only on UserID. Suppose I have several stores, and a user of a store want to add a transaction to his store. Of course I don't want use to add a transaction to a store which is not his/her. Please help, I'm using ASP/VBScript.
Tom
|
|
|
 |
rrodgers
|
| Posted: 06/17/2003, 6:40 AM |
|
You don't say what tools you are using. CC or CCS?
It would be very similar to how you would do it based on UserID. What I would do is if the person can only update one store add a field into the User table for the store ID. After login I would put the StoreID into a Session Variable.
Session("StoreID"), Then I would Filter the Grids by this Session var. And Place a hidden field on the update forms that has a default value of the session id. There is a current thread with the subject... "update and view own records logged in users "
rob
|
|
|
|
Tom
|
| Posted: 06/17/2003, 3:21 PM |
|
Thank you, Rob. That's really helpful. I've a follow-up question though.
What about if some user has access to more than 1 store?
Tom.
|
|
|
|
rrodgers
|
| Posted: 06/17/2003, 3:27 PM |
|
I use a second table that holds the userid and storeid. A Many:Many table.
|
|
|
|
|
