Global Fields for Employee Names

[luiscovar]

I have two attached pictures which my help on what i am talking about. I have the Employee ID in the employee picture, which will be used to find the name, middle name and last name of the employee.

 

The goal here is to have the employee ID be the get(accountname) login, so that way the data base will automatically know the name of the person. However, i want to be able to have the name of that person across all the records on the other layout. I know about global fields but don't know exactly how they work. There will be more than one employee, so I dont' know if global fields work for more than one option. 

 

Also, I made the date global on the attachment where there is an option for a data. I made it like this so it sticks throughout the records but when i change the date it also changes the ones before that. Is there anyway i can make it only change the current ones being accessed?

[Fitch]

Global fields only persist for the current user's current session.

If you change the date in a global field, it's not going to change that date for any users but you, and it's not going to show that date next time you log in.

I'm not clear what you're wanting to do, but if you want to set the date for a group of found records, you could for example create a script that does a Replace in a non-global date field, and trigger that script when you change the global date.

As for the user, I typically set the user's account name into a global field or variable via a script that is set to trigger when the file first opens.

[luiscovar]

I'll give you a run down of the purpose of the database to get my message across better.

 

It's a task database, so an employee goes and does 34 tasks in one day. He/She will say whether it was completed or not. The idea is to have a have a layout (the second one attached above) with a date field and an employee field that will automatically be entered in. The date field should be the same throughout the whole records. I'd like it for the date to only be chosen once and then set throughout the other records. 

 

The employee name is linked to the their employee ID (like in the attachment above). What i want to do with this is make their username their employee ID, and somehow make the employee id be automatically inputted(by getaccount name). I'm not sure if it would have to be a global field but I want the employee name field to automatically be field out in the second attachment throughout the whole records. 

[comment]

What i want to do with this is make their username their employee ID, and somehow make the employee id be automatically inputted(by getaccount name).

 

I believe you are describing two things: first, define a text field in the Tasks table to auto-enter: Creation [Account Name]. Then define a relationship to a Users (or Employees) table, matching on AccountName. Place fields from this table on your layout to display the employee's name, etc. (make sure they cannot be entered in Browse mode, to prevent accidental modification).

 

Note that this assumes an employee's account name will never change.