>>>I have a form which displays all names in my table. When an individual logs onto my system with only *individual* rights, I want him to see only his data. How do I go about setting this filter, when they log in I have the record number stored to a public variable. Now when they enter ANY form it verifies the access level. I need to be able to read the contents of my variable that stores their record number and display only that record. I keep going to the top of my table, and I don't want that. The data environment is tied to each form so I am dealing with the cursor. Any help would be appreciated
>>
>>I would suggest to have AutoOpenTables to .F. so you can modify the filters in the Load() and then do OpenTables().
>
>also, you'd probably want to use conditional indexes (faster than filters)
And, depending on your forms, you may wish to control data by creating a cursor a runtime which shows only that users data. (Works great for combo box, or grid lists which ship to a detail screen)!
John
John Adams
John T. Adams
Software Consulting Services