>As Michel said: add a field to each table to hold the user identification code. When a normal user enter the application, issue a SET FILTER TO USERFIELD=USERCODE. When you save a record, you must REPLACE USERFIELD WITH USERCODE. This way, each user will see only the records created by himself.
>
>For Supervisor, you will not issue a SET FILTER command. So, he will see the entire database.
>
>If your database is a very large one, I suggest you to create an index on USERFIELD. This way you will take advantage of Rushmore technology (you don't need to set order to this index). The index must be in a CDX index file.
That's a very complete information for him.
BTW Nice signature you have now. :)