Gordon,
>How do I get the FullName of the current user that is logged in?
>
>The user logs into the system. The system looks up the userid and password and validates them. The user enters into the system.
>
>I assume that the User information is available somehow. Is the fullname stored as a Session variable? Do I need to pull the name from the table again via the UserPK?
>
>I would like to store the User Name on the records that they create (Client Request).
From a normalization perspective it would be preferable to store the user's PK in the records they create instead. This saves quite a bit of data storage space, and if the user's name changes (for example, because of marriage), then you only have to change the name in one place.
The user's PK is store in the session variable "mmUserSecurity_UserPk". If you want to get the full name, you do need to retrieve it from the user's table.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com