Do these people travel or are they pretty much stationary to their locale? If they are stationary, then you can use a user table to store where they are located and based on their login, grab the data from that user table.
They are stationary. When you say user table, what do you mean? there is no personal info in the accounts/privileges except for the login and password. If I need to create it how will connect it to my main table so that is auto inputs the person and location?
Define a user table with at least two fields:
AccountName and Location
Define a matching AccountName field in your table with the Auto-enter feature you described
Relationship in Manage | Database | Relationships:
YourMainTable::AccountName = LocationTable::AccountName
Now you've linked your two tables by account name. You can either use the above relationship to refer to the above location field dynamically or you can specify a "looked up value" option for a text field if you'd rather capture a "snapshot" of the location data as it existed at the time the record was created.
[Edit fixed some minor typos]
Thank you PhilModJunk. This worked perfectly. Sometimes the answers are so simple we don't see them. I think I am making things harder than they are. 2 thumbs up for PhilModJunk!!!