How do I default userid or systemid to track who made changes to table or which employee data entered particular record or records. I am lost on how to do it, please
Set the default value of the field or hidden text box to something that returns the username.
For example, environ ("username"), returns the windows environment variable username. Assuming you are using an Active Directory domain and Windows 2000 and later systems, that should work fine.
If you implemented access security, you could use currentuser().
The default property you specify would look something like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.