Jump to content

Account Name vs Name


mike60640
 Share

This topic is 4388 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello, I have not worked much with server side authentication and only delt a little bit with file security settings and all of that was years ago. So I'm back now building a bigger project.

I am designing a database and want to auto enter who created each record. I know later on I'll be dealing with each users privileges and log-ins. So, what is the difference with (when defining a fields auto entering criteria) "Account Name" and "Name"?

Thanks

Link to comment
Share on other sites

Common question. Account Name is preferred. User Name is the value in FM Prefs on the workstation (useless, imho).

You may wish to also populate a StaffID_created, if you worry account names may change.

Link to comment
Share on other sites

Thanks

You may wish to also populate a StaffID_created, if you worry account names may change.

What do you mean by this? The records data should not change even if the user's account information or login changes. Are you talking about creating a whole lookup for StaffID #s to use instead so if login changes they will still be under the same ID?

Link to comment
Share on other sites

Yes. I do a find in an Open Script in the Staff table where AccountName = Get (AccountName). Then I capture gStaffID. All tables have an auto-entered number field, _kF_StaffCreatedID = gStaffID. So, when Mary gets married and wants her account changed, I don't care.

Link to comment
Share on other sites

OK. So a simple use of an AccountCreated field with the entry option of populating this field with AccountName.

I usually have in each table:

zz_AccountCreated

zz_AccountModified

zz_TimeStampCreated

zz_TimeStampModified

Link to comment
Share on other sites

This topic is 4388 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.