I searched around for this, but couldn't find anything exact. Hopefully this is not a common question.

I have an application (about 20 files) which I'm designing, but for the purpose of this question I basically have 3 files including a login file with a couple global fields that validate against a user file and then the actual application files.

I need to keep the username global from the login throughout the remaining files so I have a way to define a relationship back to the user file a pull information about the logged in person (for example automatically insert his or her name).

I tried setting up a script that would copy and past from one file to another, but it doesn't seem to work.

Any help would be appreciated

I think I got it to work by inserting a calculated result of the field from the login file. Is there a better way to do this?

You could set up a constant relationship from all the files back to the login file, and then you have immediate access to all the fields in that file without the need to copy/paste, or insert data into fields in the other files.