How to assign a particular user to edit his own data only

Applications Control
#1

hi
i have an employee database
i want user to be able to update only his data and not of any other person’s
how can i do this?
subodh

#2

Re: How to assign a particular user to edit his own data only

When you create the grid, setup the SQL to only load their own records

SELECT * FROM table WHERE id_user = [id_login_user]

If you want to have users view all, but only allow edit of their own, then create 2 forms and call the EDIT form if they load their own, else the VIEW app.

Regards,
Scott.

#3

Re: How to assign a particular user to edit his own data only

thanks scott,
i have already purchased scriptcase and i am having some small problems in making my application
please answer my other questions in the other forum
subodh