Multi user question

[coffeec]

I am setting up a system to run about 10 different database files. When a user logs onto the main file to login to the database, will this login info be carried over to the other files as they are called? Also, some of these other files have records that will only be shown to the user that created that record. How can I setup the system so that only the records entered by the user are shown in the main DB file and the other DB files as they are called? I hope this is not to confusing.