filtering the records using userid's

HI All, I would like to view the records on the basis of user id’s. Each user has to see and modify the records that they have created. How to restrict the users to view the records of their that no one can see the other user records. Thanks in advance Ramesh

Hi, You can add a field USERsID to the record. In the OnInsert of the record you put; USERsID := USERID; USERsID is the field in the record. USERID is the USERID (C/AL symbol menu, DATABASE, Functions, USERID) of the current user. To view only records users have created themselves, you can use the property RunFormView of the commandbutton you use to open the form. When you insert records in the same form, you have to put in the OnInsertRecord of the form; USERsID := USERID;